Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multi box Values (from date value to text value)

Hi,

I am using an excel to develop reports.

I have column named 'week_ending _date'.

Values in the column are:

5/6/2011  12:00:00 AM

5/13/2011  12:00:00 AM

2/17/2012  12:00:00 AM

11/30/2012  12:00:00 AM

2/8/2013  12:00:00 AM

So, I have Weekly data from 2011 - 2013     

From this I should create a Multi box Property but the values in the multi box should be-

Current week

Previous week

Current QTD

instead of the values which are there in data.

How do i achieve this? Can any one please let me know the query for this?

I have attached the Sample excel.

Thanks in advance.

Labels (1)
0 Replies