topic Re: Variables in Set Analysis in QlikView

Variables in Set Analysis

Fri, 04 Jan 2013 10:41:50 GMT

Hi,

I have a table chart with a list of customers highlighting their Gross Profit

For some reason QV has the GPs of each customer exactly the same in my report

However when I specify 1 customer I'm given the correct GP

Here are the details...

I have 2 variables

And this set analysis expression - sum({<[FinancialYear]={'$(vCurrentFY2)'}>}vGP)

Is there a reason why variables will not work in set analysis?

Many Thanks

khadeer — Fri, 04 Jan 2013 11:03:42 GMT

first of all check ur variables, its giving correct result r not, n if they r right

try this, just i changed ' to "

sum({<[FinancialYear]={"$(vCurrentFY2)"}>}vGP)

hope it will works

Fri, 04 Jan 2013 11:12:25 GMT

The variables are ok.

If I use this expression I get the completely wrong values

sum({<[FinancialYear]={'$(vCurrentFY2)'}>}calGP/val)

If I change the ' to " I still receive the same results

Fri, 04 Jan 2013 11:38:24 GMT

I used this expression instead to come to a solution, it works now

sum({<[FinancialYear]={'$(vCurrentFY2)'}>}calGP) / sum({<[FinancialYear]={'$(vCurrentFY2)'}>}val)

Thanks for the help.