topic Set Analysis division in QlikView

Set Analysis division

Fri, 07 Mar 2014 10:48:26 GMT

Hello,

I'm trying to perform a division in Set Analysis, within a pivot table. Both of the below formulae are correct when displayed individually, but when I add the division '/' symbol, no value is returned.

Could someone please let me know the correct syntax?

(Sum ({<BILLED_TIME.PERIOD={$(YTD)}, TIME.PERIOD_FIN_YEAR = , INT_DATE => } BILLED_TIME.BILLED_AMT))
/

(Sum ({<BILLED_TIME.PERIOD={$(YTD-1)}, TIME.PERIOD_FIN_YEAR = , INT_DATE => } BILLED_TIME.BILLED_AMT))

Thanks, Gavin

Re: Set Analysis division

alexandros17 — Fri, 07 Mar 2014 10:50:59 GMT

The second formula returns 0?

Re: Set Analysis division

MK_QSL — Fri, 07 Mar 2014 10:52:30 GMT

Looks wrong in BILLED_TIME.PERIOD={$(YTD-1)}

What is your YTD variable.. i.e. can you let us know the definition of it?

Re: Set Analysis division

Fri, 07 Mar 2014 11:02:07 GMT

Thank you both. Manish, you were correct - a silly mistake by me; YTD-1 should have been PTYD.