Issue on Graph

qlikviewaf — Wed, 13 Dec 2017 09:41:35 GMT

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

Re: Issue on Graph

sunny_talwar — Wed, 13 Dec 2017 09:50:26 GMT

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...