Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i make a table with week range

Hi community,

I want to make a table like this but i dont knwo what expression i can make

Week    Sales

31-41     100M

32-41      90M

33-41      65M

Can anyone tell me how to do it

5 Replies
Not applicable
Author

And also i have a range of week 27-45

How can i set the range be 31-41?

tresesco
MVP
MVP

Could you provide a sample input data and expected output against that?

Not applicable
Author

I have the following expression now

Dimension:class(Floor(Week),1)

Measurement:Sum(DISTINCT {<Week = {">=$(=31)<$(=41)"} >} LineTotalSales )

The outcome is:b5c73483ff30432495a3028e7086d993.jpg

Not applicable
Author

But i WANT

31<X<41

32<X<41

33<X<41

34<X<41

what should i modify in order to get the dimension likes this

tresesco
MVP
MVP

For these uneven intervals class() alone might not be enough here. I guess you might have to take some help from the-as-of-table‌ concept or, a little complex and not-so-nice solution using synthetic dimension. Try to share your sample raw data (in excel may be).