topic Re: Date Calculation in QlikView

Date Calculation

upaliwije — Sat, 20 Sep 2014 12:14:56 GMT

Hi all

I have attached QV document where I have created a Pivot Table. But when I collapse Following fields

figure do not appear

Total Days, Days Left and Unused Amount.

But when I expand the table figure do appear. I want to show figures when fields are collapsed as well. Pls help me

Re: Date Calculation

MK_QSL — Sat, 20 Sep 2014 12:18:39 GMT

Change your expressions

SUM(TOTAL_DAYS)

SUM(DAYS_LEFT)

Re: Date Calculation

upaliwije — Sat, 20 Sep 2014 12:25:05 GMT

still the unused amount does not get calculated

Re: Date Calculation

MK_QSL — Sat, 20 Sep 2014 12:31:15 GMT

SUM(if(DAYS_LEFT>0,NRP,0))*(DAYS_LEFT/TOTAL_DAYS)

Re: Date Calculation

upaliwije — Sat, 20 Sep 2014 12:57:38 GMT

Thanks for you reply

but still the unused amount remain blank. Pls try with my example and reply

thanks

Re: Date Calculation

sundarakumar — Sat, 20 Sep 2014 13:01:52 GMT

This is bec when u r collapsing multiple values are returned for a single dimension entry, u should use an aggregate function to it like sum(), max(), etc...

-sundar

Re: Date Calculation

upaliwije — Sat, 20 Sep 2014 13:04:57 GMT

Could u please modify in my QV document and upload back

Re: Re: Date Calculation

sundarakumar — Sat, 20 Sep 2014 13:30:13 GMT

FPA. Please let me know if it is correct or u want some logic to be implemented on it.

Re: Re: Date Calculation

Anonymous — Sat, 20 Sep 2014 13:35:01 GMT

here is it

Re: Date Calculation

upaliwije — Sat, 20 Sep 2014 15:30:15 GMT

Thanks all