Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Shubham_D
Partner - Creator
Partner - Creator

Comparing 2 fields in dimension for Filter - QlikSense

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.

@sunny_talwar  @rwunderlich 

Rgdsm

Shubham

Labels (3)
3 Replies
sunny_talwar

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)

 

Shubham_D
Partner - Creator
Partner - Creator
Author

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

sunny_talwar

I am not sure I know how this can be handled. May be someone else might know