How to create a weekly report

[Luffy20]

Hi 

I have data as below ,with this data i want to create a weekly report to show data of 7 days in a week

I need  data to show only from 20231201 to 20231207 , can you help me with this

[RamanaKumarChintalapati]

Hi @Luffy20 ,

Please follow  the below links:

https://community.qlik.com/t5/App-Development/How-to-show-only-last-7-days-rows-Qlik-Sense-Table/td-...

https://community.qlik.com/t5/New-to-Qlik-Sense/Plotting-last-7-days-in-bar-chart/td-p/1806682

Thanks!!

[Luffy20]

I need to show the complete details of the previous week , not sum or count,can you help me

[Anil_Babu_Samineni]

@Luffy20 Perhaps this way? But still not sure where you are trying this 🙂

If(Date(Date)>=Date(Max(Date-14)) and Date(Date)<=Date(Max(Date-7))

[Luffy20]

I had two weeks of data , i need to show only one week data without filtering

[RamanaKumarChintalapati]

Hi @Luffy20 ,

You want to show only one week data without filtering, So where you want to know

like in any Table or any other visual

or when loading data itself restricting data to one week 

Please clarify Where you want to show data

Thanks!!!

[Luffy20]

In a Table

[RamanaKumarChintalapati]

hi @Luffy20 ,

I think your requirement like this below

Below is the expression:

=if([Order Date] >= Max(total [Order Date]) - 6 AND [Order Date] <= Max(total [Order Date]), [Order Date])

Hope it works for you!!

Thanks!!!