topic Month vs Quarter in QlikView

Month vs Quarter

Fri, 03 Apr 2015 18:32:00 GMT

Hi, guys!

I have a tricky problem here. I have a pivot table as follows:

I have a condition for Becnch USD calculation depending on the period, if it is > or < than current month

My expression:

IF(Month_Date>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

However when it comes to quarters it doesnt give me the desired result.

The quarters are in the same table with Month_Date in my load script.

Thnx!

Anonymous — Sat, 04 Apr 2015 04:22:11 GMT

it would be great if you can share sample qvw

mohammadkhatimi — Sat, 04 Apr 2015 05:38:46 GMT

Hi...Diana...

Please post a sample application...

Regards,

Mohammad.

PrashantSangle — Sat, 04 Apr 2015 05:46:09 GMT

Hi,

Try with below expression,

IF(Month_Date>=(vCurMonth),Sum({<Month_Date={">$(=vCurMonth)"}>} Sal*Bench_Data),Sum({<Y={'2015'},Month_Date={">$(=vCurMonth)"}>}Fact_bench))

Regards

Sat, 04 Apr 2015 14:33:00 GMT

Hi,

Unfortunately, this doesnt work

Sat, 04 Apr 2015 14:42:25 GMT

Hi,

How can I add a document here? cant find a button

Sat, 04 Apr 2015 16:05:35 GMT

maybe this will work?

IF(min(Month_Date)>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

Anonymous — Sat, 04 Apr 2015 16:16:07 GMT

on right top of reply box see blue link use advanced editor click that and then on right bottom you will get link to attach files