topic Re: help in set analysis expression in QlikView

help in set analysis expression

Anonymous — Sun, 28 Feb 2016 09:02:42 GMT

I have been struggling with set analysis for couple of hours .

Below is my expression

Set Expression:

Sum(ActualDay)-Sum(History Day)

Sum(History Day)

Please find the data in attached document .

In the attachement 'Assumed answer' is the desired result

'R/H % Daily ' is displaying null value

I am getting wrong outputs with the above expression. The expression is correct .I have cross checked each individual aggregation when i combining the all the three expression for growth it is giving me wrong results .i think it was with brackets in the epxression i was going wrng.

for eg:

the expresiion is displaying '-'

but when i am calculating individually it is some where close to -16%

Help me out to resolve .

Thanks

Re: help in set analysis expression

swuehl — Sun, 28 Feb 2016 10:41:12 GMT

That's hard to answer without knowing more details about your data, model and context of the expression.

It would be best if you could upload a small sample QVW that demonstrates your issue.

At least post the output of each individual sum, the context (used in a chart? with which dimensions and user selections?) and explain how the two fields are related to each other and how your variable is defined.

Re: help in set analysis expression

petter — Sun, 28 Feb 2016 11:19:03 GMT

You say you have crossed checked each individual calculation. What does that mean? Did you calculate the same the two sub expressions in the same chart - a straight table or pivot table I would presume?

What does the vMTD variable contain? How is it defined?

Re: help in set analysis expression

sunny_talwar — Sun, 28 Feb 2016 12:21:10 GMT

What are each of these sums come out to be individually? May be we can see what number it is calculating by looking at the numbers for each of them separately.

-> Sum({<CalDate={'>=$(vMTD)<=$(=Max(CalDate))'}>}CY_DAY_QTY)

-> Sum(LY_DAY_MTD_QTY)