Conditional Show/Hide in Qlik Sense

[bmaheshwari]

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.

[tresesco]

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]

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 ?

[tresesco]

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