Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sum Total in Set Analysis

I have the below expression but How can I put that in set analysis ?

IF(_BTUnitOfMeasure = 'SQF',Sum(Total([RSF])),

                                                 Sum(Total([RSF])) * VarSfTOM2)

Thanks much.

1 Solution

Accepted Solutions
Highlighted

May be like this:

RangeSum(

Sum(Total {<_BTUnitOfMeasure  *= {'SQF'}>}[RSF]),

Sum(Total {<_BTUnitOfMeasure  -= {'SQF'}>}[RSF]) * VarSfTOM2)

View solution in original post

3 Replies
Highlighted

May be like this:

RangeSum(

Sum(Total {<_BTUnitOfMeasure  *= {'SQF'}>}[RSF]),

Sum(Total {<_BTUnitOfMeasure  -= {'SQF'}>}[RSF]) * VarSfTOM2)

View solution in original post

Highlighted
Specialist III
Specialist III

You can make it something like this:

=Sum(Total {<_BTUnitOfMeasure = {'SQF'}>} ([RSF])) + Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>} ([RSF])) * VarSfTOM2

Let me know if you got it right

Best regards,

D.A. MB

Highlighted
Creator
Creator

Thank you.