Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Contributor III

## show last seven days date in graph in qlik sense

Hi All,

I am stuck in one formula can any body help me please. I need to show last seven days dates in bar graph based on current date.

Labels (2)

• ### SaaS

1 Solution

Accepted Solutions
Contributor III
Author

Hi got the solution

i make a field in load editor If(WeekDay(TempDate)<>'Sun',IF(TempDate>=(TODAY()-8)and(TempDate <TODAY()),'Last 7',''),'') as Sevenday      and then i make measure =Date(If(Sevenday='Last 7',CallDate,''),'MM/DD')

and it works for me thank you.

4 Replies
Specialist

try

EXP-  Sum({<Date={"<=\$(=Day(today()))>=\$(=Day(today())-7)"}>}amount)

Contributor III
Author

Not working please see the below image. Showing invalid value.

Specialist

could you attach here your sample data

Contributor III
Author

Hi got the solution

i make a field in load editor If(WeekDay(TempDate)<>'Sun',IF(TempDate>=(TODAY()-8)and(TempDate <TODAY()),'Last 7',''),'') as Sevenday      and then i make measure =Date(If(Sevenday='Last 7',CallDate,''),'MM/DD')

and it works for me thank you.