topic Re: Conditional Display of Charts in QlikView

Conditional Display of Charts

Fri, 19 Aug 2011 08:43:11 GMT

Hi all,

I have a filter named Quarter_Num and I have 4 charts. The values for Quarter_Num are 1,2,3,4.

I want to show only chart1 if Quarter_Num=2,3,4. (filter has multiple selections)

Similarly, chart2 if Quarter_Num=1,3,4

chart3 if Quarter_Num=1,2,4

chart4 if Quarter_Num=1,2,3

I gave Quarter_Num<>2 to display chart2. But its not working. Please suggest your solutions.

Thanks in advance.

Re: Conditional Display of Charts

Wed, 24 Aug 2011 09:56:30 GMT

Hi all,

Please help me with the display condition.

Re: Conditional Display of Charts

its_anandrjs — Wed, 24 Aug 2011 10:01:09 GMT

Hi,

If you want to display any chart conditionally you need to put some thing like this

for

1. If ( Quarter_Num = 2 or Quarter_Num = 3 or Quarter_Num = 4, Quarter_Num)

2. If ( Quarter_Num = 1 or Quarter_Num = 3 or Quarter_Num = 4, Quarter_Num)

3. If ( Quarter_Num = 1 or Quarter_Num = 2 or Quarter_Num = 4, Quarter_Num)

4. If ( Quarter_Num = 1 or Quarter_Num = 2 or Quarter_Num = 3, Quarter_Num)

you need to put this condition for one chart one by one.

Regards

Anand

Re: Conditional Display of Charts

kaushiknsolanki — Wed, 24 Aug 2011 12:28:10 GMT

Hi,

This condition is right.

Make sure you are placing this condition at Layout Tab of the Chart Properties.

Not in "General Tab"

Regards,

Kaushik Solanki

Re: Conditional Display of Charts

its_anandrjs — Wed, 24 Aug 2011 12:30:55 GMT

Hi,

A suggestion is work for you or not please confirm me and let me know if you has an sample so provide me.

Regards

Anand

Re: Conditional Display of Charts

Thu, 25 Aug 2011 05:17:32 GMT

Hi Anand,

The expression is not working. I tried with

If ( QUARTER_YR_NUM = 2 and QUARTER_YR_NUM = 3 and QUARTER_YR_NUM = 4, QUARTER_YR_NUM) .

But it is also not working.

Re: Conditional Display of Charts

its_anandrjs — Thu, 25 Aug 2011 07:01:33 GMT

Hi,

Can you share any sample file for that.

Regards,

Anand