Issue on Graph

[qlikviewaf]

Hi Guys,

i have a simple report table, where the user have to select the Measure and Dimension that would like to see.

The thing is that for the "Measure", there's something that sometimes doesn't work. Here below an example:

User has selected "Costs PY" but as you can see on the report also appears "Sales" as measure.

Anyone knows where is the bug ?

Here how the script is build

[sunny_talwar · Accepted solution]

The problem is that 1 is also part of 11, so when you select Cost PY, Sales comes for free... change all your conditional expressions to this

Sales

=SubStringCount(Concat('|' & _metricsNo & '|'), '|1|')

Cost PY

=SubStringCount(Concat('|' & _metricsNo & '|'), '|11|')

etc...