topic Re: Monthly value % calculation in QlikView

Monthly value % calculation

Tue, 01 Mar 2016 05:51:42 GMT

Hi All,

I have a requirement as follows

the dimension is Month and Company.

i need to find the market share for each company in manufacturing market.

so i have kept the dimension as both MonthYear and company.and it is a line chart which shows individual lines for company.

now the Expression should be in such way that it should take

current month value for each company

Current month value for all companies

Now the issue is when i using this exp

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}total SALES)

Then the numerator will give the output fr each month where as in denominator it will take for whole year.But it should not be the case.

But when i select a Month then i will get correct output..

But more than one Month is selected then again the result will be wrong.

Can anyone help me with this?

Thanks in advance.

Regards,

Reena

Re: Monthly value % calculation

Anonymous — Tue, 01 Mar 2016 05:53:48 GMT

any sample data?

Re: Monthly value % calculation

Chanty4u — Tue, 01 Mar 2016 05:54:14 GMT

did u tried wit ALL

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}AllSALES)

Re: Monthly value % calculation

PrashantSangle — Tue, 01 Mar 2016 06:07:16 GMT

Hi,

add <MonthYearField> after TOTAL keyword

sum({<Type={'Current'},AREA={'MANUFACTURE'}>}SALES)

sum({<Type={'Current'},AREA={'MANUFACTURE'},COMPANY=>}total<MonthYear> SALES)

regards

Re: Monthly value % calculation

Tue, 01 Mar 2016 06:10:55 GMT

when i am using ALL it will take the entire sales irrespective of Moth and year

Re: Monthly value % calculation

Tue, 01 Mar 2016 06:14:34 GMT

Thanks a lot ..

It worked.

new Learning..

Re: Monthly value % calculation

Chanty4u — Tue, 01 Mar 2016 06:20:59 GMT

Hmmm ....

if u got the solution.please close the thread by making correct and helpful answers.

Thanks

Suresh chanty

Re: Monthly value % calculation

Tue, 01 Mar 2016 08:30:42 GMT

Done..Already..