Dimension using Chart Question

[#1]

I have a chart in Qlikview.  I also created a flag in my code that assigns a value of 1.  The flag is called _tmflg.

In the chart I want to limit the sheets display of information unless the _tmflg =1

I am not sure if  I need to do a calculated dimension and say _tmflg=1 or if I need to do something else in the chart (ie Dimension limits, Expressions to filter out those records that do not have a _tmflg =1

[prabhuappu · Accepted solution]

Hi,

You can create a calculated dimension and check for _tmflg=1 and enable suppress null values check box.

if(_tmflg=1, <Dimension Field>)

Regards,

Prabhu Appu

[#3]

Thank you

[#4]

Is there a way to also use the same flag to filter out information in a table box similar to the diagram you show here?

[prabhuappu]

you can't use calculated dimension in table box. But you can suppress null values in table box. So set the flag as either one or null in the script level and use that in table. Then enable the suppress null value.

you can't achieve this if you don't want to show the flag field in table.

regards,

Prabhu Appu