Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
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