topic Re: Qlikview Sum for <= vMaxMonth in QlikView

Qlikview Sum for <= vMaxMonth

Mon, 14 Sep 2015 13:25:53 GMT

I have a variable vMaxMonth which holds the maximum month based on the selection.

I want to use set analysis to find sum of amount for all values <= vMaxMonth.

I am using

sum({<Month={'<=$(vMaxMonth)'}>} amount)

But it does not give the desired results.

Request to guide what is wrong in my expression.

Re: Qlikview Sum for <= vMaxMonth

teiswamsler — Mon, 14 Sep 2015 13:30:24 GMT

Hi tripti

I cant quite get what you are after, maybe this can help.

This set analysis is to calulate current month to date (MTD), based on current selection i filters.

OrderDate is numerisk.

Sum( {<
CalenderYear,
CalenderMonth,
CalenderQuater,
%OrderDate = {">=$(=num(MonthStart(Max(%OrderDate))))<=$(=Max(%OrderDate))"}
>} Sales )

/Teis

Re: Qlikview Sum for <= vMaxMonth

tresB — Mon, 14 Sep 2015 13:32:49 GMT

This could be because of mismatch in Month data format., i.e. - your Month field might have data like 'Jan', 'Feb',... while your variable has numeric value. So you have to get them in sync. Try to share your problem app with sample data.

Re: Qlikview Sum for <= vMaxMonth

sasiparupudi1 — Mon, 14 Sep 2015 13:43:39 GMT

Fieldnames are case sensitive and

put $(vMaxMonth) in a text object to see what value it is returning and compare it with the Month Values and they should both be in the same format

hth

Sasi

Re: Qlikview Sum for <= vMaxMonth

Mon, 14 Sep 2015 14:45:00 GMT

Thanks everyone, the issue is resolved. My expression was correct and it was issue with the other condition I was using.

Re: Qlikview Sum for <= vMaxMonth

teiswamsler — Tue, 15 Sep 2015 09:07:47 GMT

Hi Tripti

Remember to close the trend.

Have a good day.

/Teis