topic Re: SET ANALYSIS - DATE in QlikView

SET ANALYSIS - DATE

Tue, 13 May 2014 07:41:11 GMT

HI All

i have case where in i need to show the current sales and previous sales in the same table based on the selection user makes i had written an set analysis script as below

Current Sales =SUM({$<DATE={"$(vMaxdate)"}>}Sales)

PreSlaes = SUM({$<DATE *={"$(vPrevDate)"}>}Sales)

this works fine if i select the day but the previous sales values remains zero when the selection is on month

kindly suggest

Thanking You

Vinayagam

Re: SET ANALYSIS - DATE

anbu1984 — Tue, 13 May 2014 07:54:09 GMT

Try without *

PreSlaes = SUM({$<DATE ={"$(vPrevDate)"}>}Sales)

Re: SET ANALYSIS - DATE

its_anandrjs — Tue, 13 May 2014 07:59:00 GMT

Try this way

Current Sales =SUM({$<DATE={'$(vMaxdate)'}>}Sales)

PreSlaes = SUM({$<DATE ={'$(vPrevDate)'}>}Sales)

Current Sales =SUM({$<DATE={"$(vMaxdate)"}>}Sales)

PreSlaes = SUM({$<DATE ={"$(vPrevDate)"}>}Sales)

Re: SET ANALYSIS - DATE

Tue, 13 May 2014 08:09:08 GMT

yup Sir even tried the same but still not working in case of the month

Re: SET ANALYSIS - DATE

its_anandrjs — Tue, 13 May 2014 08:11:54 GMT

What are the expression in the vMaxdate and vPrevDate.

Re: SET ANALYSIS - DATE

Tue, 13 May 2014 08:17:16 GMT

HI SIR

EXPRESSION AS BELOW

vMaxdate=MAX(DATE)

vMaxdate=DATE(AddMonths(Max(DATE),-1))

Re: SET ANALYSIS - DATE

sureshbaabu — Tue, 13 May 2014 08:31:25 GMT

I guess the issue is beacuse of having multiple years of data. I Believe this will work only when you select an Year from your data.

Thanks

Re: SET ANALYSIS - DATE

its_anandrjs — Tue, 13 May 2014 08:51:39 GMT

Try with this expressions and put YourMonthFieldHere= in both the expressions.

Current Sales =SUM({$<YourMonthFieldHere=, DATE={"$(vMaxdate)"}>}Sales)

PreSlaes = SUM({$<YourMonthFieldHere=, DATE ={"$(vPrevDate)"}>}Sales)

Eg:-

Current Sales =SUM({$<MonthField=, DATE={"$(vMaxdate)"}>}Sales)

PreSlaes = SUM({$<MonthField=, DATE ={"$(vPrevDate)"}>}Sales)