Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ClaudiaS220388
Contributor III
Contributor III

% Horizontal and total horizontally

Hello everyone,

I have had some inconveniences to be able to get the percentage horizontally, for example:

ClaudiaS220388_0-1615337044341.png

I have tried the following:

=Count(Ticket)/rangesum(before(Count(distinct TICKET),0,ColumnNo(TOTAL)))

Is it possible to position a column on the right where only the totals of the previous columns are shown?

It is just giving me the percentage of the current column with the previous column ..

Help me please

 

Labels (1)
3 Replies
Vegar
MVP
MVP

Could this expression solve this issue?

=Count(Ticket)/count(total <Name>Ticket)

 

Anil_Babu_Samineni

If you are expecting last 2 column you required workaround using Inline table to match exact required output with measures. Can you please attach sample QVF to get the output?

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
ClaudiaS220388
Contributor III
Contributor III
Author

Thank you very much for your answer, however it does not solve my problem.

I add image of my table.

I need to get the percentage of the total that I mark in yellow.

Example:

2021-03-05
# / Total Horizontal (the last record in the row)

2021-03-06

#/Total Horizontal (the last record in the row)

2021-03-07

#/Total Horizontal (the last record in the row)

You must take the last record of the stack of the row that is marked in yellow (Total Horizontal)

ClaudiaS220388_2-1615390802528.png

It is possible that the columns that are marked in blue do not show the amount and only see at the end of the row what is the horizontal total marked in yellow?

Best regards