Discussion Board for collaboration on QlikView Scripting.
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!
IF you are looking for Qlikview then you need to implement the comprehensive analysis
PFA Documents .
Try Like this, pls notify the fields exactly
Hope this helps !
Use alternate States to Compare a value of 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&'|')