topic wtd Sales in QlikView

wtd Sales

Tue, 28 Jul 2015 05:07:25 GMT

I have written a expression so that sale quantity not change week selection but still its keep on changing week selection

sum({<Year=,Num_Month=,NumWeekDay=, Week=,[Posting Date]=,Posting_Day=,PostingDateNum={'>=$(vMinDate_AMS11)<=$(vMaxDate111)'}>}[Sale Quantity]))

What wrong in this expression

robert_mika — Tue, 28 Jul 2015 05:09:48 GMT

maybe:

sum({<Year=,Num_Month=,NumWeekDay=, Week= ,Posting_Day=,PostingDateNum={'>=$(vMinDate_AMS11)<=$(vMaxDate111)'}>}[Sale Quantity]))

Tue, 28 Jul 2015 05:21:15 GMT

jagan — Tue, 28 Jul 2015 05:26:37 GMT

Hi,

Check your variables are changing based on the selection, if variables change the values of the expression will also change.

sum({<Year=,Num_Month=,NumWeekDay=, Week=,[Posting Date]=,Posting_Day=,PostingDateNum={'>=$(=vMinDate_AMS11)<=$(=vMaxDate111)'}>}[Sale Quantity]))

Can you attach the sample file?

Regards,

Jagan.

Tue, 28 Jul 2015 05:28:50 GMT

vMinDate_AMS=

num(date(AddMonths((vMaxDate)+1,-12),'DD/MM/YYYY'))

vMaxDate111

num(date(max([Posting Date]),'DD/MM/YYYY'))

Tue, 28 Jul 2015 05:32:40 GMT

vMaxDate=

date(max([Posting Date]),'DD/MM/YYYY')

vMinDate_AMS=

num(date(AddMonths((vMaxDate)+1,-12),'DD/MM/YYYY'))

vMaxDate111

num(date(max([Posting Date]),'DD/MM/YYYY'))

Tue, 28 Jul 2015 05:34:00 GMT

where VminDate_AMs used for calculating last 12 months data

Kushal_Chawda — Tue, 28 Jul 2015 05:39:52 GMT

I think in variable $(vMaxDate111) you have to change the expression.

I am assuming you have expression as max(Date), so you can write expression as max({<Week>}Date)

sasiparupudi1 — Tue, 28 Jul 2015 11:40:26 GMT

Make sure that you have the date in PostingDateNum the format same as in your variables