topic Re: Each Year Month Sales in QlikView

Each Year Month Sales

mdmukramali — Tue, 07 Apr 2015 06:25:45 GMT

Dear All,

I have a requirement. where end user wants to see the each year last month( Max_Month) sales.

if no selection on months than,

2010- DEC sales

2011- DEC sales

2012- DEC Sales

2013- DEC sales

2014- DEC sales

2015- APR Sales.

if he makes any selection on month filters than that month sales need to see in all the years.

And i need to take year as dimension.

so please any suggestions on above requirement.

Thanks,

Mukram.

Re: Each Year Month Sales

Tue, 07 Apr 2015 06:36:57 GMT

hi,

=sum({<FinYear={'2015'}>} sales)

=sum({<FinYear={'2014'}>} sales)

when you will select any month it will give month results.else it will give whole year sales value.

Regards

Vimlesh

Re: Each Year Month Sales

mdmukramali — Tue, 07 Apr 2015 06:57:01 GMT

Dear Gupta,

i need Max Month Sales for each Year without any selection.( default )

Re: Each Year Month Sales

Tue, 07 Apr 2015 07:04:06 GMT

hi,

pass your month in this set analysis through variable or by hard coded.

sum({<FinYear={'2015'}, month={'Apr'}>} sales)

sum({<FinYear={'2015'}, month={=$(vmaxmonth)}>} sales)

Regards

Vimlesh

Re: Each Year Month Sales

Tue, 07 Apr 2015 07:07:54 GMT

hi,

sum({$<AYear={$(vYear)},Months={$(vMonth)},Day={$(vDay)} >}[sales])

here if you want by pass values means you put Day= means no effect of day selection in this set analysis

sum({$<AYear={$(vYear)},Months={$(vMonth)},Day= } >}[sales])

Regards

Vimlesh

Re: Each Year Month Sales

pokassov — Tue, 07 Apr 2015 07:09:51 GMT

Hi, Mohammed!

First of all, we could add flag FinalMonth in our Calendar table, to use it in set analysis to select last months.

expr1: sum({$<FinalMonth={1}>}sales)

Then we could add variable "vMonth": =if(GetSelectedCount(Месяц)>0, false(),true())

Finally you can write expression:

if(vMonth, $(expr1), sum({$<Month={$(=max(Month))}>} sales)

Sergey

Re: Each Year Month Sales

nagarjuna_kotha — Tue, 07 Apr 2015 07:14:57 GMT

Hi Mohamad,

Yes We can do that,

use below expression

if (getselected count(plant)=0,

Sum({< Dept={'Sales'} , Plant={'Total'} Value}

Sum({< Dept={'Sales'} , Value}

)))

Try this....

Re: Each Year Month Sales

mdmukramali — Mon, 13 Apr 2015 07:18:47 GMT

Dear ,

Thanks for your help.

i did something like this.

Created a FLAG in the Back End.

if(MONTH=MAX_MONTH,1,0) AS FLAG.

Created a Variable.

vMonth=if(GetSelectedCount(MONTH)>0, 0,1)

Expression:

=if(vMonth=1, (Sum({<FLAG={'1'}>}BUDGET)+Sum({<FLAG={'1'}>}INCOME)),

(sum({$<MONTH={$(=max(MONTH))}>} BUDGET)+sum({$<MONTH={$(=max(MONTH))}>} INCOME)))

Thanks,

Mukram