topic Re: Set Analysis Syntax Error in QlikView

Set Analysis Syntax Error

rileymd88 — Thu, 10 Dec 2015 11:13:02 GMT

Hi,

I am trying to create an expression which is restricted to only sum when the calendar day in my data table equals the variable I have set via the load script called vLatestDay, however this is not working. Here is what I have in the expression:

Calendar day = Date dimension

vLatestDay = Variable date

WH Stock = The value I am trying to sum

Expression:

Sum({$<[Calendar day]={'>=$(=vLatestDay)'}> } [WH Stock])

Can you please let me know if the syntax for the expression is OK? It does not seem to give me the expected result

Thanks,

Re: Set Analysis Syntax Error

tamilarasu — Thu, 10 Dec 2015 12:14:18 GMT

Hi Riley,

Try,

Sum({$<[Calendar day]={">=$(=vLatestDay)"}> } [WH Stock])

Sum({$<[Calendar day]={">=$(vLatestDay)"}> } [WH Stock])

Make sure date format for the field Calendar day and variable vCurrentMonth should match.

Re: Set Analysis Syntax Error

Kushal_Chawda — Thu, 10 Dec 2015 12:21:39 GMT

Expression looks ok. what is the expression for vLatestDay?

Re: Set Analysis Syntax Error

Anonymous — Thu, 10 Dec 2015 12:23:16 GMT

Expression looks okay, just bypass the Date Field, make sure Format should be common throughout..

try this:

=Sum({$<DateField= ,[Calendar day]={'>=$(=vLatestDay)'}> } [WH Stock])

Re: Set Analysis Syntax Error

sebastianlettner — Thu, 10 Dec 2015 13:50:21 GMT

Hi,

first, you use a single quote, you should use a double qoute.

A Primer on Set Analysis

What is the value of vLatestDay, is it a value or a expression? Try to remove the equal sign.

The Magic of Variables

Is vLatestDay in the correct format?

Why don’t my dates work?

Get the Dates Right

Regards

Sebastian Lettner