topic Re: Need urgent logic in QlikView

Need urgent logic

Mahamed_Qlik — Fri, 28 Apr 2017 17:29:48 GMT

Hi All,

I need below below resulting table. Kindly help with logic:

Logic for Result column is -

Initially it needs to set as value 3 (hard coded ok), later it should be

Result column = Opened - closed +Result

Please help me what expression and variables need to set to get above table.

Best Regards,

Mahamed

m_woolf — Fri, 28 Apr 2017 18:15:37 GMT

Something like:

load

Opened - Closed + peek('Result') as Result

from MyTable

order by Date;

Anonymous — Fri, 28 Apr 2017 18:17:07 GMT

rangesum() would be better? or?

Mahamed_Qlik — Fri, 28 Apr 2017 18:25:40 GMT

Hi,

I need this to be done on front end.

Because there is separate expression written for opened an closed column .

Mahamed_Qlik — Fri, 28 Apr 2017 18:26:12 GMT

Can you please give me expression?

Anil_Babu_Samineni — Fri, 28 Apr 2017 18:28:48 GMT

May be this?

For last column, I used full accumulate

Anil_Babu_Samineni — Fri, 28 Apr 2017 18:35:03 GMT

Or May be expression this?

Rangesum(Below(Sum(Opened)-Sum(Closed),0),Above(Sum(Opened)-Sum(Closed),1,RowNo()))