topic Conditional Display in QlikView

Conditional Display

Mon, 26 Sep 2011 07:35:28 GMT

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.

Conditional Display

kaushiknsolanki — Mon, 26 Sep 2011 07:46:22 GMT

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

Re: Conditional Display

SunilChauhan — Mon, 26 Sep 2011 08:01:02 GMT

see the attached file

hope this helps

Re: Conditional Display

Mon, 26 Sep 2011 09:10:40 GMT

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.

Re: Conditional Display

SunilChauhan — Mon, 26 Sep 2011 09:22:33 GMT

o i am sorry

please see the attached file

hope this helps you

Conditional Display

kaushiknsolanki — Mon, 26 Sep 2011 09:54:55 GMT

Hi,

Can you tell me why you need four different charts, if all chart have almost same expression.

Regards,

Kaushik Solanki