how to display last 5 working days trend in qlikview/Qliksense?

pgrs4219 — Sat, 16 Nov 2024 00:28:48 GMT

Hi All,

I know I've posted this question earlier , But didn't get proper direction Yet.

Here is the requirement: I've to show last 5 business days trend depends on date selected.Attached the document where i have tried date-5 , apparently its not fulfilling my need when there is gaps in the Date Field.For instance here i selected 06 jan 20 it has go back to 5 available date from the Date Field. pleases refer to the attached do for better understanding Kindly provide me the fix or ideas to achieve this. thanks

Re: how to display last 5 working days trend in qlikview/Qliksense?

lironbaram — Tue, 16 Jun 2020 05:40:38 GMT

this expression should work for you , it finds the index of the max value than add 4 values for the index and convert to the value

=Count({<Date={">=$(=date(FieldValue('Date',FieldIndex('Date',max(Date))+4),'DD MMM YY'))<=$(=DATE(Max(Date),'DD MMM YY'))"} >}SalesAmount)

topic how to display last 5 working days trend in qlikview/Qliksense? in QlikView

how to display last 5 working days trend in qlikview/Qliksense?

Re: how to display last 5 working days trend in qlikview/Qliksense?