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: 
achakilam1022
Creator II
Creator II

Adding time frames as rows in a table

Hi all,

Could you please help me create a table where I can add different time frames as rows and metrics as columns


qlik time frame table.JPG

Currently, I have calendar script to calculate current day flag, previous day flag, current week flag, previous week flag and last 30 days flag. Wondering if I could somehow use these flags to create this table.

Thanks!

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Think you need a value list

check below

ValueList() – For those tricky situations

you value list will be 'Current Day', 'Previous Day' ....

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Think you need a value list

check below

ValueList() – For those tricky situations

you value list will be 'Current Day', 'Previous Day' ....

achakilam1022
Creator II
Creator II
Author

Thanks!

dplr-rn
Partner - Master III
Partner - Master III

No problems. let me know if any questions.

Close thread if it worked out