Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner
Partner

If fieldvalue exist, then you need to make a selection to show the expression:

As the headline show.


I have salary structures for different countries. For some countries I have several salary structures due to big differences between for example Paris and RegionalFrance.

For some countrys i however have only one structure. Then I just choose the field country = Germany.


So I want to write an expression for the table so that If a value exist for Location (example Paris). Then I need to select Location in the filter also. Otherwise it will just show a message like "You need to select".

1 Reply
Vegar
Partner
Partner

I've attached a qvf as an example where I've used this inline data script;

Data:
LOAD * INLINE [
Country, Location,  	Amount
Germany, , 				100
France, Paris, 			100
France, RegionalFrance, 100
Sweden, , 				100
Norway, Middle, 		100
Norway, South, 			100
Norway, North, 			100
];

 

The show condition is: =count(Location)<=1

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes