topic Re: Revesre cummulative with difficult logic in QlikView

Revesre cummulative with difficult logic

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

Hi All,

I ahve a very difficult logic to implement in a line chart . please look into my beow explanantion

Difficult logic:

I need to show a line chart by month .

I have month as dimension and in expression I am using this logic "

Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno()))

For the above reverse cummulative expression works fine as shown in the figure below . Now i want to add the total count of id's to the max month . how can i achive this .

If i get the total count for the year added to the Oct month then it will cummulate .

Can any one please help me on this .

Thanks in Advance

Re: Revesre cummulative with difficult logic

smilingjohn — Wed, 21 Oct 2020 13:36:01 GMT

Hi Community any help on this ?

Re: Revesre cummulative with difficult logic

smilingjohn — Thu, 22 Oct 2020 05:23:12 GMT

Hi community

Is my requirements possible ??

Re: Revesre cummulative with difficult logic

MayilVahanan — Thu, 22 Oct 2020 07:27:31 GMT

Hi @smilingjohn ,

Try like below

If(MonthYear = Max(Total MonthYear), count({<Status={'Closed'},Dept={'Incometax'}>}Total ID),

Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno())) )

Hope it helps

Re: Revesre cummulative with difficult logic

smilingjohn — Thu, 22 Oct 2020 10:53:08 GMT

Thanks @MayilVahanan

I tried your expression but this is not working properly ...

Re: Revesre cummulative with difficult logic

smilingjohn — Thu, 22 Oct 2020 11:08:05 GMT

Currently this is how my data looks .as shown in the figure . the total ID's are 11 , now this 11 Id's should get added to Sept which should be like 11+4=15 and this 15 should get added to Apr=2+15 and so on till Jan2018 .

Re: Revesre cummulative with difficult logic

MayilVahanan — Thu, 22 Oct 2020 11:26:18 GMT

HI @smilingjohn

Try like below

If(MonthYear = Max(Total MonthYear), Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), count({<Status={'Closed'},Dept={'Incometax'}>}ID)),

Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), Count({<MonthYear={'$(=Max(MonthYear))'},Status={'Closed'},Dept={'Incometax'}>}ID))+Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,NoOfRows())) )

Re: Revesre cummulative with difficult logic

smilingjohn — Thu, 22 Oct 2020 11:51:49 GMT

@MayilVahanan

Thanks Your expression works .

Thanks a lot sir .