Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
achakilam1022
Contributor 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
dilipranjith
Honored Contributor

Re: Adding time frames as rows in a table

Think you need a value list

check below

ValueList() – For those tricky situations

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

3 Replies
dilipranjith
Honored Contributor

Re: Adding time frames as rows in a table

Think you need a value list

check below

ValueList() – For those tricky situations

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

achakilam1022
Contributor II

Re: Adding time frames as rows in a table

Thanks!

dilipranjith
Honored Contributor

Re: Adding time frames as rows in a table

No problems. let me know if any questions.

Close thread if it worked out