Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Conditional Display

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.

Tags (1)
5 Replies

Conditional Display

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

chauhans85
Esteemed Contributor

Re: Conditional Display

see the attached file

hope this helps

Not applicable

Re: Conditional Display

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.

chauhans85
Esteemed Contributor

Re: Conditional Display

o i am sorry

please see the attached file

hope this helps you

Conditional Display

Hi,

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

Regards,

Kaushik Solanki   

Community Browser