Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IF you are looking for Qlikview then you need to implement the comprehensive analysis
PFA Documents .
HTH
Vikas
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
Hi Federica,
Use alternate States to Compare a value of variable with all the values of another variable.
-Sateeesh
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