Show last 7 days of calendar year in a table as dimension

[Anonymous]

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

[sunny_talwar]

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'))"}>}

[fvelascog72]

Hi,

You can generate it in script:

DATA:

LOAD

  Date(Today() - 1 + Rowno()) as "Dimension"

AutoGenerate 7;

Saludos.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Got it!!!! Go to the number tab and select date format

This was it!?

#Qlikisdarkandfulloftricks

[Anonymous]

But im not getting the calculated dimension in Number tab

[sunny_talwar]

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?

[Anonymous]

True! Sorry i was doing it from List box object. I will investigate

[lorenzoconforti]

Maybe:

=Date(ValueLoop(today()-7,today(),1) ,'DD/MM/YYYY')