topic Dimension using Chart Question in QlikView

Dimension using Chart Question

Wed, 28 Jan 2015 16:38:44 GMT

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

Re: Dimension using Chart Question

prabhuappu — Wed, 28 Jan 2015 18:17:54 GMT

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

Re: Dimension using Chart Question

Wed, 28 Jan 2015 18:39:58 GMT

Thank you

Re: Dimension using Chart Question

Wed, 28 Jan 2015 20:48:55 GMT

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?

Re: Dimension using Chart Question

prabhuappu — Thu, 29 Jan 2015 02:22:30 GMT

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