topic Re: Comparing 2 fields in dimension for Filter - QlikSense in App Development

Comparing 2 fields in dimension for Filter - QlikSense

Shubham_D — Sat, 16 Nov 2024 01:49:29 GMT

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

Re: Comparing 2 fields in dimension for Filter - QlikSense

sunny_talwar — Wed, 29 Jul 2020 12:42:34 GMT

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)

Re: Comparing 2 fields in dimension for Filter - QlikSense

Shubham_D — Mon, 17 Aug 2020 09:23:52 GMT

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

Re: Comparing 2 fields in dimension for Filter - QlikSense

sunny_talwar — Mon, 17 Aug 2020 15:02:46 GMT

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