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: 
Not applicable

How to compare a value of a variable with all the values of another variable

Hi!


I have a Pivot Table with only one dimension, let's say Dimension1.

I also have 2 different variables, let's say Variable1 and Variable2.

To a value of Dimension1 correspond a value of Variable1 and a value of Variable2.

What I want to do is to compare the row-value of Variable1 with all the values of Variable2 (and not only with the value corresponding to that row).

hope it's a little bit clear!

Thanks

4 Replies
vikasmahajan

IF you are looking for Qlikview then you need to implement the comprehensive analysis

PFA Documents .

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
krishna20
Specialist II
Specialist II

Hi,

Try Like this, pls notify the fields exactly

(sum({<CE_EST_TYPE={"=CE_EST_TYPE=1"},CE_DT={"=CE_DT<=Today()"},

CLM_SOURCE_FM={"=CLM_SOURCE_FM=CE_SOURCE_FM"},

CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"}>}CE_AMT_LC_1)

Hope this helps !

Regards

Krishna

sat_tok52
Creator
Creator

Hi Federica,

Use alternate States to Compare a value of variable with all the values of another variable.

-Sateeesh

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Just to clarify, I think you want to compare field values, not variables, correct? For fields F1 and F2, how about:

SubStringCount('|'&Concat(DISTINCT TOTAL F2,'|')&'|', '|'&F1&'|')

-Rob

http://masterssummit.com

http://robwunderlich.com