Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Sum by rows of a specific measure

How could I do sum by rows of a specific measure?

If I implement the classic sum by rows I obtain totals for all measures.

thanks

6 Replies

Re: Sum by rows of a specific measure

Not sure what you mean? May be using the TOTAL Qualifier?

Sum(TOTAL <FieldName>Sales)

Not applicable

Re: Sum by rows of a specific measure

Example: dim  A B, C  for columns

               expressions : M1 M2 M3

I need to visualize only the total by rows of M1  and not for all the measures.

Re: Sum by rows of a specific measure

Would you be able to share a few rows of sample data with the expected output?

Not applicable

Re: Sum by rows of a specific measure

Capture2.PNG

I'd like to show only the qty total and not both

Re: Sum by rows of a specific measure

Oh I see what you mean. AFAIK it won't be possible, but I loved to be proved wrong

Not applicable

Re: Sum by rows of a specific measure

Thank you very much

Community Browser