Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksense30
Contributor III
Contributor III

Need help as the data is not correctly popualting

Hi All,

 

I have a different scenario .

I have three filters  and in the chart , i kept a condition based on the currency.

Now i have one query , if the customer chooses currency (filter)as 'local', then  the chart should  show display message that "it needs to get  select one country" as i have multiple countries , then only the chart should get displayed for the list box Currency local value  . Please find my attached qvw here as i have given for 2 countries .

 

 

 

Labels (1)
3 Replies
qliksense30
Contributor III
Contributor III
Author

Hi Anyone can please look into it

jwjackso
Specialist III
Specialist III

In Qlikview create a text object with your message, add a conditional statement like below which will display the text object if local is set and more than 1 country is selected.

=If(GetFieldSelections(currency) = 'local' ,If(GetSelectedCount(country) = 1,0,1),0)

In the chart, add a similar conditional statement to hide chart if local is selected and more than 1 country is selected.

=If(GetFieldSelections(currency) = 'local', If (GetSelectedCount(country) = 1,1,0),1)

qliksense30
Contributor III
Contributor III
Author

Hi,

I have a chart now which  tells that  atleast need to slect on filetr  value from 3 fields( Currency,Metric Type,  Consolidation).

Now my concern is for the Currency  filter i have field value called Local.

if the user selects Local, then the chart has to show display message as please select  only one country , then  only the  logic for the local wil display. 

 i have given for sample for 2 countries data. Actually i have multiple countries in my dashbaord

How to do that, Can anyne please help