class Function

nilesh_gangurde — Sat, 07 Apr 2012 09:00:03 GMT

Heyy,

I want to create the date buckets, I have used the class function for that but i am facing some problem. I have explain it in the document attached.

Please help me its urgent..

Thanx in Advance.

Regards,

Nilesh Gangurde

Re: class Function

Jason_Michaelides — Sat, 07 Apr 2012 09:47:33 GMT

Hi Nilesh,

I don't think I'd use a calculated dimension like you have done. Instead, just have Customer as the dimension and use a set analysis expression to decide which sales to sum. I have created 2 new variables (vDateFrom and vDateTo) which give the range of your selected date plus the width. Then, the expression is:

=Sum({<Date={">$(vDateFrom)"},Date={"<$(vDateTo)"}>} Sales)

See attached - NEW CHART

Hope this helps,

Jason

topic Re: class Function in QlikView

class Function

Re: class Function