topic Re: Set Analysis formula expanation in QlikView

Set Analysis formula expanation

Thu, 25 Dec 2014 08:47:34 GMT

Hi All,

I have gone through the set analysis threads. Even though I have some doubts.

Could you help me the below code what does it do?

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales / $(vCurrency))

Thanks in advance.

Re: Set Analysis formula expanation

mdmukramali — Thu, 25 Dec 2014 08:57:49 GMT

Dear,

The Below Expression will give the sales of the Max Year and Previous Year

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales

Thanks,

Mukram

Re: Set Analysis formula expanation

MK_QSL — Thu, 25 Dec 2014 09:01:41 GMT

This will give you Total Sales for the Max Year (or Max Selected Year) plus the Previous Year..and the result will be divided by vCurrecy Variable to convert to the respective currency.

If your data model has data from year 2010 to 2014.. and there is not selection at all for year, you will get total sales for Year 2013 and 2014 but if user has selected year 2012, you will get sales of 2012 and 2011.

Hope this will helps..

Happy Qliking...!

Re: Set Analysis formula expanation

Thu, 25 Dec 2014 09:07:23 GMT

Many thanks

Re: Set Analysis formula expanation

Thu, 25 Dec 2014 09:07:44 GMT

Hi manish,

i have x-axis data liek 0-5,5-10,10-15...

i want show it in percentage like 0-5%,5-10%,10-15%.... how?

Re: Set Analysis formula expanation

MK_QSL — Thu, 25 Dec 2014 09:15:33 GMT

@Manojqlik... kindly create separate thread and don't mix with someone else thread... Thanks