Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi all,
Please help me with the display condition.
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
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
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
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.
Hi,
Can you share any sample file for that.
Regards,
Anand