Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bmaheshwari
New Contributor

Conditional Show/Hide in Qlik Sense

Hello sir,

i want to display Chart Conditionally Show/Hide from database 

Sql Query for this :

select  IsShow from  [tablename]
where FieldKey = 'XXXXX' 

here if IsShow = 1 then show  else hide chart

can you please suggest how we apply this condition in Bar/Line Chart in  Qlik Sense .

Thanks.

3 Replies
MVP
MVP

Re: Conditional Show/Hide in Qlik Sense

Try something like:

=Max({<FieldKey={'XXXXX'}>}IsShow)=1


Or,   // based on your expectation and possible number values in fields


=Only({<FieldKey={'XXXXX'}>}IsShow)=1

bmaheshwari
New Contributor

Re: Conditional Show/Hide in Qlik Sense

Can you please suggest where/how i can apply this condition in Line chart ?

means under Appearance which section i can add this condition in Chart ?

Highlighted
MVP
MVP

Re: Conditional Show/Hide in Qlik Sense

In qlik Sense, try using Add-ons ->Data Handling'-> Calculation Condition