Last 7 days Revenue

[nihhalmca]

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.

[kaushiknsolanki]

Hi,

Change the expression to.

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

Regards,

Kaushik Solanki

[nihhalmca]

No change kaushik. 

[nihhalmca]

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. 

[kaushiknsolanki]

Hi,

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

Regards,,

Kaushik Solanki

[nihhalmca]

Hi Kaushik - Please find the sample file.

[-SW- · Accepted solution]

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 !

[nihhalmca]

Hi Shun, thanks for your help.

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

[-SW-]

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.

[nihhalmca]

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