topic Re: Set Analysis Issue in QlikView

Set Analysis Issue

Sat, 22 Nov 2014 08:40:23 GMT

Hi All,

I am currently using SET Analysis on my dashboard and the outcome is really weird.

I have used the following code to set the year and month for revenue :

=sum( {< DocumentDateYear= {$(vCurrentYear)}, Month= {$(vCurrentMonth)} >} GrossBillAmt)

vCurrentYear = Year(Reloadtime())

vCurrentMonth = Month(Reloadtime())

The answer is coming wrong as 0.00

When I tried the same code using dummy data on other machine it worked correctly. I am not sure what is the error in my code. I did check the machines date and time setting as well, it is correct

Thanks in advance.

Re: Set Analysis Issue

Sat, 22 Nov 2014 08:44:32 GMT

Hi,

Please check, you have the data for the Year=2014 and month =November.

if you do, then please check that you had that data for the respected dimension, for which you want to create expression.

With Regards

Harshita Gaur

Re: Set Analysis Issue

its_anandrjs — Sat, 22 Nov 2014 08:53:15 GMT

Hi,

1. How you create your variables if it is Ctrl + Alt + V then check weather you put the equal sign in front of the expression or not like for below variables.

vCurrentYear =Year(Reloadtime())

vCurrentMonth =Month(Reloadtime())

2. Also check the values of the variables in the text object ex:- =vCurrentYear &' - '&vCurrentMonth

And your expression is correct

=sum( {< DocumentDateYear= {$(vCurrentYear)}, Month= {$(vCurrentMonth)} >} GrossBillAmt)

Regards

Anand

Re: Set Analysis Issue

maxgro — Sat, 22 Nov 2014 14:04:20 GMT

sum({<DocumentDateYear={$(=year(reloadtime()))}, Month={$(=Month(reloadtime()))}> } GrossBillAmt)

if doesn't wotk, check Month values and Month(reloadtime()) value

Re: Set Analysis Issue

SunilChauhan — Sat, 22 Nov 2014 15:04:17 GMT

I am not sure weither DocumentDateYear=current is available or not

DocumentDateYear

you could try this

=sum( {< DocumentDateYear= {"$(vCurrentYear)"}, Month= {"$(vCurrentMonth)"} >} GrossBillAmt)

or you could use below

=sum( {< DocumentDateYear= {"$(=Year(Reloadtime()))"}, Month= {"$=(Month(Reloadtime()))"} >} GrossBillAmt)

or you could attched sample file .