topic How can i make a table with week range in QlikView

How can i make a table with week range

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How can i make a table with week range

Thu, 10 Aug 2017 05:05:49 GMT

And also i have a range of week 27-45

How can i set the range be 31-41?

Re: How can i make a table with week range

tresB — Thu, 10 Aug 2017 05:13:44 GMT

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

Re: How can i make a table with week range

Thu, 10 Aug 2017 05:30:34 GMT

I have the following expression now

Dimension:class(Floor(Week),1)

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

The outcome is:

Re: How can i make a table with week range

Thu, 10 Aug 2017 05:31:42 GMT

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

Re: How can i make a table with week range

tresB — Thu, 10 Aug 2017 06:04:10 GMT

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).