Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have calculated dimension in filter object as below,
If(Column1= column2, column1)
It's working fine, but the issue is when I select anything in Column1 filter, Column2 also comes in FIlter pane as well.
How to ignore this, also I am not been able to compare the same in script as both are from different tables and had some another relations.
Please help.
Rgdsm
Shubham
Are they both coming from the same table? If they are why not create a new field in the script
If(Column1 = Column2, Column1) as New_Column1
and then use this as your filter object. You can also use it to create a flag and then use the flag in your filter pane. Something like this
If(Column1 = Column2, 1, 0) as Flag
and then a filter object like this
Aggr(
Only({<Flag = {1}>} Column1)
, Column1)
Hi @sunny_talwar ,
Thanks for the revert.
No, they are not from same table otherwise I would have created the same flag .
Other thing is if I am using a condition on column like below then also if someone selects value from column then each IF condition creates selection in the pane,
If(getSelectedCount(A)=1 or getSelectedCount(C)=1, B)
If select Value from B then A & C filter will also get appear in the pane.
Rgds,
Shubham
I am not sure I know how this can be handled. May be someone else might know