Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nilesh_gangurde
Partner - Specialist
Partner - Specialist

class Function

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

1 Reply
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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