Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just wonder if there is an option to do the following:
I have two filters:
1. Profitable Companies based on 4year weighed average
2. Profitable Companies based on 3year weighed average
Obviously it does not make sense to use both at once. Thus, i am wondering if there is an option to use something like "getfieldselections" or something similar to actual deactivate one filter if the other one has been selected. (each filter works as a dummy variable, there is either a company marked as profitable based on the weighed average relevant for the type of calculation, or value is a null)
thx
bringing up my post:
also, I have tried something as the following code:
if(getfieldselections([Three Years History]) = 'Three Years History',
if([Company earned weighted average operating loss] = 'Accepted', 'Profitable Companies 3Y'),
if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))
This works following:
Filter Three Years History not active & the above presented filter not active --> all working fine (obviously)
Filter Three Years History active & the above presented filter not active --> all working fine
Filter Three Years History active & the above presented filter active --> all working fine
last option
Filter Three Years History not active & the above presented filter active --> activation of this while Three Years Filter is not active starts some weird actions
1. it activates automatically the filter Three Years History
2. activates the if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))
3. gives nonsense results as it is combining the options that are basically impossible to combine
3y history + average based on 4years...
is this a bug or is this intended?
I Mean I would expect that this would work in a following logic
"If there is current selection x, use this filter, else use that filter" and that is it.. this seems that having that if(getfieldselections) in a given filter I can actually activate the other filter value which seems very weird to me.
Edit: Added a qvf (simplified version where you can see the functionality of what I mean, each filter is there as typical Qlik Filter as well as "list box version" second one is an extension.