Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
lorita2021
Contributor II
Contributor II

no values ​​displayed by default when opening the qlikview dashboard

Hello every one, 

I have a report which displays some graph according to a chosen workstation in the search bar.

lorita2021_0-1617096627421.png

If I choose no workstation, all the workstations will be displayed in the table and in the graphs it will be the total of all the workstations.

lorita2021_1-1617096771216.png

I wish that at the opening of report no particular workstation will be selected by default and that the table and the graphs will be empty ( no data).

Any idea please ?

Thanks

4 Replies
MayilVahanan

HI @lorita2021 

Try like below

In the chart,

Properties -> General tab

MayilVahanan_0-1617097790299.png

 

=GetSelectedCount(workstationfieldname)>0

--- 

Chart will display only atleast one workstation is selected.

 

For clear all workstation, you can add Onopen trigger in Document properties

MayilVahanan_1-1617097871497.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
lorita2021
Contributor II
Contributor II
Author

Thanks for your reply, but this solution does not meet my need 😞.

I want that at the opening of the dachbord there will be no workstation selected and that all the report elements will be empty of data. if i don't select any one , all workstations will be selected by default

 

lorita2021
Contributor II
Contributor II
Author

I need to add a null value in a filter along with other values for a field workstation. how can I add a null value among the choices please?

 

MayilVahanan

HI @lorita2021 

You can hide the entire chart / show the chart based on condition. 

You can add null value in the script or NA in the script for null values. Can you elaborate ur requirement with some sample data.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.