Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
My dashboard has 4 buttons Quarter1, Quarter2, Quarter3, Quarter4. And I have a field named Quarter_Number with values 1,2,3,4.
When we click the following buttons, the following field values are selected.
Button Quarter_Number
Quarter1 2,3,4
Quarter2 1,3,4
Quarter3 1,2,4
Quarter4 1,2,3
I have 4 charts. I want to enable conditional display for the charts. When Quarter1 is clicked, Chart1 is selected and so on.
Currently i have given the condition Quarter_Number<>1 to display only chart1. But its not working.
Please post your replies.
Hi,
Try this expression.
For chart 1 - if(match(quarter_number,2,3,4),1,0)
For chart 2 - if(match(quarter_number,1,3,4),1,0)
and so on.
Regards,
Kaushik Solanki
see the attached file
hope this helps
Hi Kaushik,
Thanks for your reply. But its not working. I will explain the current scenario. I have a listbox 'Quarter_Number' and button 'Quarter1'. When the button is clicked, the values 2,3, and 4 will be selected simultaneously. Only the value 1 will remain unselected. And when I click button1, I want to display only chart1. Hope you understood my problem.
just for your information I will give the expression used in chart1.
if(Quarter_Number<>1,Sum({$<MONTH_SID={">=$(q1_low)<=$(q1_high)"} >}NEW_JOINEE_FLAG))
MONTH_SID is a firld used to select month range from the 2 variables.
Hi Sunil,
I think you posted the reply under wrong discussion.
o i am sorry
please see the attached file
hope this helps you
Hi,
Can you tell me why you need four different charts, if all chart have almost same expression.
Regards,
Kaushik Solanki