Hiding Measure Columns / Flags

[Anonymous]

In QlikView, we are able to create measures which flag certain information. When you drop the flag into a table, there is an option to hide the output column. Resulting in a custom manipulation of the table by hiding output columns flagging only information required. Below is sample data (Measure = creating flag / Table 1 = source data / Table 2 = expected output).

Is there a way for us to hide the measure output column?
(Measure = Creating Flag)

Pattern Flag = 
SUMX(
    SUMMARIZE(
       ALLSELECTED(PizzaOrders),
        PizzaOrders[transaction_id], "Date",MAX(PizzaOrders[transaction_date])
    ), IF(
        [Date] >= CALCULATE(MIN(PizzaOrders[transaction_date]) )
        && [Date] <= CALCULATE(MAX(PizzaOrders[transaction_date]) )
        ,1, BLANK()
    )
)

(Table 1 = Source Data)

transaction_id	transaction_date	status
pizza1	Wed. Nov 25, 2020	New
pizza1	Fri. Nov 27, 2020	In Progress
pizza1	Mon. Nov 30, 2020	Baking
pizza1	Tue. Dec 1, 2020	Boxing
pizza1	Fri. Dec 4, 2020	Complete
pizza2	Thu. Nov 26, 2020	New
pizza3	Wed. Dec 2, 2020	New
pizza3	Wed. Dec 2, 2020	In Progress
pizza3	Thu. Dec 3, 2020	Complete
pizza4	Mon. Nov 30, 2020	New
pizza4	Fri. Dec 4, 2020	Canceled

(Table 2 = Expected Output)

transaction_id	transaction_date	status	Pattern Flag **HIDE THIS COLUMN**
pizza1	Friday, December 4, 2020	Complete	1
pizza2	November 26, 2020	New	1
pizza3	Thursday, December 3, 2020	Complete	1
pizza4	Friday, December 4, 2020	Canceled	1

Any advice will be greatly appreciated.

[manikumar34 · Accepted solution]

@Anonymous , 

If you just want to apply that flagg condition on your table and do not want to see on the table then the best way to apply the flag as a visual filter. 

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter

Regards, 

Manikumar

[BA_Pete]

Hi @Anonymous ,

I guess the first question would be: What are you using the flag column for? If it's for calculating other values from or for filtering/slicing, then it doesn't need to be there, it can be worked into other measures or applied as a filter in other ways.

If you really just want an invisible column in your table, then I think the closest you would get is to rename the measure in the values list to " " (space), then turn off auto-size column widths on the table and adjust that column width to zero. You could also go to Field Formatting on the format tab and set all the colours of that field to the same as your background for good measure.

Pete