topic Re: Explanation in QlikView

Explanation

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

hi all,Can any one expalin ths expression

=num(Sum({<DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} P_AND_L)/

Sum({< DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} OPENING_CAPITAL),'0.00%')

sunny_talwar — Tue, 23 Jan 2018 09:54:26 GMT

It seems to be a MTD (Month to Date) calculation of P_AND_L divided by OPENING_CAPITAL

sasikanth — Tue, 23 Jan 2018 09:54:29 GMT

HI Vignesh,

Calculating % of P_AND_L & OPENING_CAPITAL for MTD (Month to Date)

stabben23 — Tue, 23 Jan 2018 09:55:44 GMT

Looks lika a MTD KPI in %, probably in a textobject.

so if you have max Datenum today it will calculate from 1/1/2108-23/1/2018

shiveshsingh — Tue, 23 Jan 2018 10:02:42 GMT

Meaning of --- Sum({<DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} P_AND_L)

Sum of P_AND_L where datenum is greater than or equal to month start of Max(Datenum) and less than or equal to Max(Datenum)

Meaning of ---- Sum({< DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} OPENING_CAPITAL

Sum of OPENING_CAPITAL where datenum is greater than or equal to month start of Max(Datenum) and less than or equal to Max(Datenum)

Post this, they have done formating by usning '0.00%

surendraj — Tue, 23 Jan 2018 10:03:34 GMT

A KPI that shows MTD Caliculation By dividing P_AND_L with OPENING_CAPITAL and finally formated(0.00% ) by make use of num function.