topic Re: Hiding past hours from last week in comparison to same day in last week chart in QlikView

Hiding past hours from last week in comparison to same day in last week chart

milad-saeedi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart that compares my current status to the same day last week (-7d).

but my problem is the data that shows in the chart, as you can see I have data for upcoming hours from last week but I need to show them when it's time arrives not before them:

Re: Hiding past hours from last week in comparison to same day in last week chart

Zhandos_Shotan — Tue, 30 Jul 2019 06:34:41 GMT

Hi!

In your "7 days ago" expression add set analysis, something like:

Sum( {<HourDim={"<=$(=Max(HourDim))"}>} Value)

Re: Hiding past hours from last week in comparison to same day in last week chart

Vengatesh — Tue, 30 Jul 2019 06:39:04 GMT

Hi,

You can achieve this by adding NOW() function in set analysis.

Re: Hiding past hours from last week in comparison to same day in last week chart

milad-saeedi — Thu, 01 Aug 2019 09:19:16 GMT

Hi,

Thanks for your kind reply,

could you please edit my expression as you think it's true?

=Count({<CreateDate={">=$(=daystart(today()-7))<=$(=dayend(today()-7))"}>} ID)

Re: Hiding past hours from last week in comparison to same day in last week chart

Zhandos_Shotan — Mon, 05 Aug 2019 05:09:20 GMT

Hi!

You have to have native dimension with cyclic numeric hours (0, 1, 2... 23). And CreateDate dimension must be Timestamp. Depending on what you want to limit: max hour based on loaded records or current time, you can use Now() or Max(CreateDate). Your expr looks like like:

=Count({<

CreateDate={">=$(=daystart(today()-7))<=$(=dayend(today()-7))"},

HoursDim={"<=$(=Hour(Max(CreateDate)))"}

// OR HoursDim={"<=$(=Hour(Now()))"}

>} ID)