Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI There,
First let me appreciate you for taking the time out for this issue.
Now coming to the question:
I have the below data:
T1:
Load * inline [
Company,Region,CountryID,Status
A,USC,2,1
B,EMEA,5,1
C,Asia,1,1
D,Asia,6,0
E,Africa,4,0
F,Europe,2,1
];
T2:
Load * inline [
CountryID,Country
1,US
2,Germany
3,India
4,South Africa
5,Egypt
6,Japan
];
I have a filter as : If(Status = 1,Country)
It give me an option to select Germany , US and Egypt, which was expected.
When I select a value, say germany, two filters are applied simultaneously :
1. Status = 1
2. Country = Germany
I only need that The country filter is applied and not the status.
1. Can you please explain the working here. Why 2 filters are applied?
2. How can I modify the filter to get what is needed? That is only country filters.
Hi
As you use an if statement in your filter pane this is a normal behavior of Qliksense if you use this expression
If(Status = 1,Country) in this case you select Status = 1 , then relevant Country
you may have this : here status 1 is selected ( in green)
change your mesure by this one :
=aggr(If(Status = 1,Country),Country)
then you will have this : ( status is prefiltered with possible value in white and exclude value in grey)
Hope it helps