topic Re: Latest 7 days data... in QlikView

Latest 7 days data...

Fri, 20 Nov 2020 18:02:30 GMT

Hi Expert,

I have a scenario where I have to create a trend chart showing latest 7 days date from ‘EXECUTION DATE’ field.

‘EXECUTION DATE’ fields have random date in it and I want latest 7 days data (not 7 days from today date).

Please help me on this. Thank you in Advance.

Note: I tried ‘Dimension limit’ with largest 7 days but it only shows Sep’s date data.

Best Regards,

Bhavesh

settu_periasamy — Wed, 18 Nov 2015 04:24:03 GMT

Hi,

Try something like..

=Sum({<[EXECUTION DATE]={">=$(=Max([EXECUTION DATE],7))"}>}Metric_Field)

Note: Date format should be in proper format

tresB — Wed, 18 Nov 2015 04:34:09 GMT

=Sum({<[EXECUTION DATE]={">=$(=Date(Max([EXECUTION DATE],7)))"}>}Metric_Field)

jagan — Wed, 18 Nov 2015 04:53:46 GMT

Hi,

Check this link for set analysis expressions for this type of scenarios

=Sum({<[EXECUTION DATE]={">=$(=Date(Max([EXECUTION DATE]) - 6))"}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Wed, 18 Nov 2015 05:34:28 GMT

Hello,

Thank you all for your prompt reply.

Using ‘First 7 values’ instead of ‘largest 7 values’ in Dimension limits solved my issue.

BR,

Bhavesh