topic Re: Last 4 week data in QlikView

Last 4 week data

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am building a dashboard which represents data in chart for last 4 week. I have ListBoxes of Year, Month, Day.

When I select a only day it shows correct result.Ex. 03rd Dec. but when I select specific month ( like Dec), it shows data till 01st of Dec only. Again when I clear Month filter data shows correct.

For calculating I have used following set analysis.

Week1: SUM({$<[Report Day] = {">=$(=Date(Max([Report Day])-6))<=$(=Date(Max([Report Day])))"}>}[Chat Request])

Week2: =SUM({$<[Report Day] = {">=$(=Date(Max([Report Day])-14))<=$(=Date(Max([Report Day]-7)))"}>}[Chat Request])

Week3: =SUM({$<[Report Day] = {">=$(=Date(Max([Report Day])-21))<=$(=Date(Max([Report Day]-15)))"}>}[Chat Request])

Week4: =SUM({$<[Report Day] = {">=$(=Date(Max([Report Day])-27))<=$(=Date(Max([Report Day]-22)))"}>}[Chat Request])

Please help me on this..

Re: Last 4 week data

MK_QSL — Tue, 24 Jan 2017 10:29:27 GMT

Provide source data or sample application..

Re: Last 4 week data

sunny_talwar — Tue, 24 Jan 2017 10:51:07 GMT

May be you need to ignore selection in Month field?

Week1: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-6))<=$(=Date(Max([Report Day])))"}, Month>}[Chat Request])

Week2: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-14))<=$(=Date(Max([Report Day]-7)))"}, Month>}[Chat Request])

Week3: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-21))<=$(=Date(Max([Report Day]-15)))"}, Month>}[Chat Request])

Week4: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-27))<=$(=Date(Max([Report Day]-22)))"}, Month>}[Chat Request])

Re: Last 4 week data

Anonymous — Tue, 24 Jan 2017 10:58:12 GMT

Hi,

As per my understanding, you are selecting both date and month. Is it right? and you want to have data from 3rd dec to 6th November even when you selected Month. Please confirm if I'm right.

Re: Last 4 week data

Tue, 24 Jan 2017 12:55:00 GMT

Hi Sunny,

Right now we are ignoring the month field. So it generates correct result. But user friendly perspective, we cant tell others to clear month if you wish to see weekly trend.

Hi Vishwa,

Yes, you are correct.

Re: Last 4 week data

Tue, 24 Jan 2017 12:59:38 GMT

Hi Sunny,

Sorry. I did not see your comment in detailed. its actual answer.

Thanks dude

Re: Last 4 week data

sunny_talwar — Tue, 24 Jan 2017 13:00:01 GMT

That's not what I meant... Not asking users to not select it... but ignore there selection in your expression. Have you tried the expressions I gave above?

Week1: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-6))<=$(=Date(Max([Report Day])))"}, Month>}[Chat Request])

Week2: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-14))<=$(=Date(Max([Report Day]-7)))"}, Month>}[Chat Request])

Week3: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-21))<=$(=Date(Max([Report Day]-15)))"}, Month>}[Chat Request])

Week4: =Sum({$<[Report Day] = {">=$(=Date(Max([Report Day])-27))<=$(=Date(Max([Report Day]-22)))"}, Month>}[Chat Request])