Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Will the pivot table change the values automatically base on expressions?

Hi,

I have below dimension and expressions in pivot table. This will give data values between 23/06/2014 and 29/06/2014

Dimension1: Member
Dimwnsion2: Type

Expression1  =Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-7))"}, Solutions={'Open','open'}>}CustomerID)


Ecpression2  =Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-7))"}, Solutions={'Further Data'}>}CustomerID)

what my doubt is will I get the values change every week automatically based on expressions? suppose if I run the report on 07/07/2014 the table should show values between 30/06/2014 and 06/07/2014

can anyone clarify my doubt please.

Thanks.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this:


=Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-9))"}, Solutions={'Open','open'}>}CustomerID)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Yes, the today() function will return a different date on July 7 then on July 4. Therefore the expressions will return different values.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for the confirmation.

can I know please how can I change the above expression if I want the data from Monday to Friday. I,e now the above expressions will show data from Monday to Sunday. But I need Monday to Friday. I tried to change the expressions but it seems not working for me. why I am asking here we calculate the weekend data as separate. so I don't want to include weekend data in these report. Please can suggest me.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this:


=Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-9))"}, Solutions={'Open','open'}>}CustomerID)


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks.