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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.

0 Replies