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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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