Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

rajni_batra
Valued Contributor

Opening Closing with rangesum for Unique Users

Hi,

I am trying to calculate Opening and closing in front end for diff users but i am doing something wrong ,

its carry forwarding closing of all users and i want to calculate it individually for distinct users.

any help would be appreciated!!!

Thanks,

Rajni

8 Replies
kavita25
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

Hi,

PFA.

Its done as per ur requirement. Check it.

rajni_batra
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

Hi,

Kavita, Thanks for your reply.

i dont want this in back-end that would act static and if i remove any dimesnion from the chart it consolidate the opening and closing or i have to add some more expressions to get min and max of opening and closing.

Any way to do it in front-end.

Refer the file attached.

Thanks

kavita25
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

Y do you need to remove the dimensions??

Or even if dimension is removed, how the calculation should flow.?

kavita25
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

Hi,

PFA

Done.Check it. Same result is done in front end.

And if you want to remove the dimension you need to remove that field from Aggr function as I have used in the expression.

Hope it helps you now.

Regards,

Kavita

sasiparupudi1
Honored Contributor III

Re: Opening Closing with rangesum for Unique Users

Hi You need an aggregate function in your opening balance calculation

  aggr(rangesum(

    above(total sum(Bonus),1,RowNo(total))

    ,above(total -sum(Real),1,RowNo(total))

    ),UserID,UniqueID,Type,MoneyFlag, CreatedDateTime)

rajni_batra
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

Nope, Not working , After removing the date dimesnion and the same from aggr too , its picking up value of previous user.

rajni_batra
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

No luck

kavita25
Valued Contributor

Re: Opening Closing with rangesum for Unique Users

What is the expected output after removing the Date dimension?

Community Browser