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: 
shea
Contributor
Contributor

How do I restrict a newly defined date column based one the entire column of the table

I want to create a date range for a weekly reporting. I have a table with a defined set of measures from my table. I created a new column with a calculated field. 

New column IS A RANGE OF DATE : Min({<[Last_7_Days]={'1'},[Transaction_Type]={'Points','Redemption'}>} DateKey) & '-' & MAX({<[Last_7_Days]={'1'},[Transaction_Type]={'Points','Redemption'}>}DateKey) 

 

Here,  I want to select an entire column but the expression would be too long. Any suggestions?! 

Labels (3)
1 Reply
Digvijay_Singh

Would be great if you can share some sample data or app along with expected output to get more details about the problem context