Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor III

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

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

PFA Documents .

HTH

Vikas

krishna20
Valued Contributor

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

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
Contributor

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

Hi Federica,

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

-Sateeesh

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

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

Community Browser