Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to show the last 7 days of calendar year in a table as dimension?
As of today it show
10/13/2017
10/14/2017
10/15/2017
10/16/2017
10/17/2017
10/18/2017
10/19/2017
I don't have separate date field for this.
Thanks
Anupama Jagan
table as in straight table? What is your expression? You can add a set analysis to all you expression to view the last 7 days
{<Date = {"$(='>=' & Date(Today() - 7, 'MM/DD/YYYY') & '<=' & Date(Today(), 'MM/DD/YYYY'))"}>}
Hi,
You can generate it in script:
DATA:
LOAD
Date(Today() - 1 + Rowno()) as "Dimension"
AutoGenerate 7;
Saludos.
But only when we add it as a dimension we will get date displayed right?
Actually this is my orginal req:
Date - to show last 7 days(calendar dates to be populated)
Approved (metric) - sum (Approved) based on Approveddate
Total(metric) - sum (Total) based on TotalDate
Date | sum(Approved) | sum(Total) |
10/13/2017 | 20 | 61 |
10/14/2017 | 30 | 62 |
10/15/2017 | 25 | 81 |
10/16/2017 | 16 | 73 |
10/17/2017 | 18 | 78 |
10/18/2017 | 19 | 91 |
10/19/2017 | 21 | 62 |
You can use an if in the dimension tab directly (not the script nor the expressions). Just add a calculated dimension in the chart and write this down:
=ValueLoop(today()-7,today(),1)
This give you the seven last days in num format.. can't come to how to pass it do date :/, but it 's close
Got it!!!! Go to the number tab and select date format
This was it!?
#Qlikisdarkandfulloftricks
But im not getting the calculated dimension in Number tab
But only when we add it as a dimension we will get date displayed right?
Not sure I understand your question? How does the raw data look for the output you have provided?
True! Sorry i was doing it from List box object. I will investigate
Maybe:
=Date(ValueLoop(today()-7,today(),1) ,'DD/MM/YYYY')