topic Re: Rolling Month Function in QlikView

Rolling Month Function

pipuindia99 — Thu, 14 Jul 2016 11:03:35 GMT

Hi,

I have Month field in dimension and in expression i am using Rand() function to get random values. now based on my selection in month i want to see the data in chart like if i choose march, then i want to see from jan to mar, if i choose may then i want to see from jan to may...

Would appreciate if anyone can help me

Re: Rolling Month Function

sunny_talwar — Thu, 14 Jul 2016 11:05:52 GMT

May be like this:

RangeSum(Above(Sum({<Month>} Rand()), 0 RowNo())) * Avg(1)

Re: Rolling Month Function

pipuindia99 — Thu, 14 Jul 2016 11:11:16 GMT

it gives error if i use in dimension, it is not taking rowno()

Re: Rolling Month Function

sunny_talwar — Thu, 14 Jul 2016 11:12:42 GMT

In dimension? The above should work as an expression

Re: Rolling Month Function

pipuindia99 — Thu, 14 Jul 2016 11:28:47 GMT

It doesnot work, it shows error in same point for rowno(), can you check if something missing

Re: Rolling Month Function

pipuindia99 — Thu, 14 Jul 2016 11:30:29 GMT

it shows only for 1 month

RangeSum(Above(Sum({<Month>} Rand()), 0 ,RowNo())) * Avg(1)

Re: Rolling Month Function

sunny_talwar — Thu, 14 Jul 2016 12:15:35 GMT

What exactly are you trying to do? I am not sure I understand the reason to use Rand() here. Can you may be provide a context?

Re: Rolling Month Function

pipuindia99 — Thu, 14 Jul 2016 12:22:47 GMT

I have a bar chart and in that i have used Month field as dimension and in expression i have written Rand(), now when i select Month as mar from a filter i want to see data from jan to mar. and i dont want to see data for the month which i chose.

Re: Rolling Month Function

sunny_talwar — Thu, 14 Jul 2016 12:25:13 GMT

How about this:

Rand() * Avg({<MonthNum = {"$(='<=' & Max(MonthNum))"}>} 1)

UPDATE: More like this:

=Sum({<Month>}Rand()*10000)* Avg({<MonthNum = {"$(='<=' & Max(MonthNum))"}, Month>} 1)

Where MonthNum is created in the script like this:

LOAD Num(Month) as MonthNum

...

Re: Rolling Month Function

pipuindia99 — Fri, 15 Jul 2016 07:44:31 GMT

Thanks Sunny, I tried a different format it works. appreciate your help