topic Set Analysis using forced Dimension values in QlikView

Set Analysis using forced Dimension values

Thu, 07 May 2015 18:15:21 GMT

Is there a way in Set analysis to force the actual value of the dimension in the chart object a value in the expression?

For eg. I have a bar chart with 2 dimensions, I would like to force the values in the first dimension A to be available in the expression as

COUNT(DISTINCT {<Region = {"=P(Maxstring(Region))"}>} CustomerID)

where Region is already a dimension in the chart along with other dimensions

ramoncova06 — Thu, 07 May 2015 22:29:23 GMT

if the dimension is already part of your table the aggregation that is done by QV will be broken by each dimension

if what you want to do is compare the results against another specific value then that can also be done

this is how you can do the possible

COUNT(DISTINCT {<Region = P({<Region={"$(=(Maxstring(Region)))"} >}) >} CustomerID)