topic Re: Last 7 days Revenue in QlikView

Last 7 days Revenue

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to show last 7 days revenue so i have implemented below variables and logic.

vMaxdate = Max(Date);

vLast7days = Max(Date,7);

Logice: count({<year,monthname,day,Date ={">=$(vLast7days)<=$(vMaxDate)"}>} Revenue)

I have filters like year, monthname and day etc. Logic is working as expected by year and monthname however if i select day filter its not showing data as expected.

Note: I understood that logic is working for maxdate (without selections) whenever i select some date it would be maxdate by the time logic not working as expected.

Can you help on this.

Thanks,

Nihhal.

Re: Last 7 days Revenue

kaushiknsolanki — Sat, 13 Aug 2016 14:26:06 GMT

Hi,

Change the expression to.

count({<year=,monthname=,day=,Date ={">=$(vLast7days)<=$(vMaxDate)"}>} Revenue)

Regards,

Kaushik Solanki

Re: Last 7 days Revenue

nihhalmca — Sun, 14 Aug 2016 16:50:20 GMT

No change kaushik.

Re: Last 7 days Revenue

nihhalmca — Sun, 14 Aug 2016 16:56:20 GMT

I think there is no change between our logics. Just our logic avoid year selection, monthname selection and day selection. If user select together it works. By the time last 7 days field shows wrong data. I hope you understand.

Thanks,

Nihhal.

Re: Last 7 days Revenue

kaushiknsolanki — Sun, 14 Aug 2016 17:03:36 GMT

Hi,

Is it possible for you to upload the qvw file which sows your problem.

Regards,,

Kaushik Solanki

Re: Last 7 days Revenue

nihhalmca — Mon, 15 Aug 2016 08:11:02 GMT

Hi Kaushik - Please find the sample file.

Re: Last 7 days Revenue

-SW- — Mon, 15 Aug 2016 11:19:49 GMT

Hi Nihal,

Please find attached solution.

I have changed your variables and expressions.

Let me know if this is what you are looking for.

Thanks,

Shun !

Re: Last 7 days Revenue

nihhalmca — Mon, 15 Aug 2016 12:55:31 GMT

Hi Shun, thanks for your help.

I hope you just added - (minus) to my variable right?

Re: Last 7 days Revenue

-SW- — Mon, 15 Aug 2016 13:00:18 GMT

Not quite... I changed the format of your variables, you can use the QV default date format (Which is numbers).

I also changed your dimension to vMaxDate, and your expression as well.

Re: Last 7 days Revenue

nihhalmca — Mon, 15 Aug 2016 13:42:49 GMT

Ok but I removed vMaxDate and added Date as dimension, it works as expected. Thanks.