topic Set Analysis in QlikView

Set Analysis

Fri, 08 Aug 2014 09:00:09 GMT

Hi All,

I am Trying to set up some set analysis,

=Sum({'$(vSet)'<CAL_YEAR = {$(vCurrYear)}, CAL_MONTH_NAME_SHORT={$(vPrevMonth)}, [DAY_OF_MONTH]<{$('<vCurrDayD')}>} calls_offered)

Where vSet is either 1 or $

vCurrYear=Current Year =2014

vPrevMonth= Previous Month=7

vCurentDayD=Current Day of Month =10

If I Remove this section :[DAY_OF_MONTH]<{$('<vCurrDayD')}, everything works, this section is there to determine the current day and calculate all calls offered for the same period in the last month to this date

What am i doing wrong?

Cheers

Re: Set Analysis

jonathandienst — Fri, 08 Aug 2014 09:13:06 GMT

This is the correct syntax

[DAY_OF_MONTH] = {'<$(=vCurrDayD)'}

HTH

Jonathan

Re: Set Analysis

jagan — Fri, 08 Aug 2014 09:50:11 GMT

Hi,

Try this expression

=Sum({'$(vSet)'<CAL_YEAR = {$(vCurrYear)}, CAL_MONTH_NAME_SHORT={$(vPrevMonth)},

[DAY_OF_MONTH]={'<$(=vCurrDayD)'}>} calls_offered)

Hope this helps you.

Regards,

Jagan.