topic Re: Need Last 14 days records with same days in QlikView

Need Last 14 days records with same days

iahmadmca1 — Mon, 07 May 2018 01:13:54 GMT

Team,

just I want one help from your side. Please help me to do this one.

Provided the below requirement.

1. In the line chart, we need last 14 days records with same days.

As for example:

If today is Monday then we need last 14 days Monday records in the line chart.

If today is Tuesday then we need last 14 days Tuesday records in the line chart.

If today is Wednesday then we need last 14 days Wednesday records in the line chart.

Line chart should be one but 14 days records should be dynamic based on todays days. Please let me know in case of any clarifications.

Thanks,

Irshad Ahmad

sunny_talwar — Mon, 07 May 2018 01:26:30 GMT

May be like this

{<WeekDay = {"$(=WeekDay(Today())"}, Date = {"$(='>=' & Date(Today() - 98, 'DateFieldFormatHere'))"}>}

iahmadmca1 — Mon, 07 May 2018 01:37:05 GMT

Thanks sunny for the quick response.Let me check and get back to you.

iahmadmca1 — Mon, 07 May 2018 04:35:07 GMT

Sunny sorry for late response.

I checked your expression based on expression the result is showing no data to display.

Please find the below screenshot for your reference.

Thanks,

Irshad Ahmad

sunny_talwar — Mon, 07 May 2018 08:32:07 GMT

Where is your expression? Sum(Sales)? Sum(Cost), Count(ID)? What calculation are you trying to perform?

iahmadmca1 — Tue, 08 May 2018 02:14:46 GMT

Hi Sunny,

I was missing to add the calculation in your expression.i did little change in your expression and now its working fine.

Thanks for helping me.

Thanks,

Irshad Ahmad