Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to group by date ( & week, month , year ) in qlikview ?

Say I have  date & sale:

I want to create a chart that would be able to group sale by day or by week or by month ....( with out using load)

Y-axis = sum(sale)

X-axis need to able to switch between(  day, week , month )

Will I be able to do this without creating the new week or month variable ?

Thanks

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Use drill down group option which suits well.

or go for cyclic group

MayilVahanan

HI

You drilldown group , in tat, use like this

Month(Date)

Week(Date)

Day(Date)

as the expression and give label in it.

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.