Solved: need help on Ad-hoc report - Qlik Community

Nagaraju_KCS · ‎2017-11-29

Hi Community,

I have done simple Ad-hoc report,

if i make selections Dimension = Year and Measure= A,B,C and Total

here total working fine 1550, total calculation A+B+C.

MY requirement, if i make single selection Measure= A and Total, i have to show my total, my total not showing because,

i have written my expression Column(1)+Column(2)+Column(3),

and if i'm make selections A, B and Total, i need to show based on selection Total.

same as A, C and Total

How to write expression total ?

Thanks in Advance...

tresesco · ‎2017-11-30

Yes, you are right, and this is because the Total column itself is getting added in such scenarios. I have got a more dynamic (a bit tricky too) expression. Try :

RangeSum($(=mid(Concat(',Column(' &ValueLoop(1,$(=Count(Measure)-1))&')' ),2)))

View solution in original post

kaushiknsolanki · ‎2017-11-29

Hi,

If this is your real time scenario then try below expression for total.

=Sum({<Company={"$(=concat(distinct Measure,'","'))"}>}Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2017-11-29

no it wont.

tell us your real scenario with real values.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Nagaraju_KCS · ‎2017-11-29

Please have a look my real example....

PFA, !

Nagaraju_KCS · ‎2017-11-30

Please can you help on this...

Anil_Babu_Samineni · ‎2017-11-30

You can use Full expression rather Column(). check and let us know. Off course, In Conditional enable you need to manipulate same thing

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Nagaraju_KCS · ‎2017-11-30

No, it won't work because it will return whole sum.

i want to change based on Measure selection.

Anil_Babu_Samineni · ‎2017-11-30

I need to look attachment, Will help you for sure once i get access the app

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

kaushiknsolanki · ‎2017-11-30

Hi Can you tell us your expected output.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Nagaraju_KCS · ‎2017-11-30

If i make all Measure selections, my total coming proper.

By My scenario, if i make any selection

0-30 and Total,

0-30, 31-90 and Total

i want to total as well...

PFA,