topic Re: Conditional Show/Hide in Qlik Sense in Visualization and Usability

Conditional Show/Hide in Qlik Sense

bmaheshwari — Tue, 12 Feb 2019 06:59:19 GMT

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.

tresB — Tue, 12 Feb 2019 07:15:33 GMT

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 — Tue, 12 Feb 2019 07:25:02 GMT

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 ?

tresB — Tue, 12 Feb 2019 07:40:03 GMT

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