Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Denis_L
Contributor III
Contributor III

Total Labels on Pivot

HI Community,

I will try to explain my problem as clear as possible.

I have a pivot table with two dimensions (QuestionText and Answer) in a rows and three (Zone, District, Dealer) in the columns .

in my expression I need to display the % of each answer in each question.

So it is pretty easy

sum({<QuestionNumber = {'30','32'}>} msrAnswerCount)

/

sum({<QuestionNumber = {'30','32'}>}total <QuestionText> msrAnswerCount).

My Problem is that in Total Labels;

I get it like this

:total labels1.PNG

But I want Like this:

Totallabel2.PNG

It is working when I do not use the Total Function in expression bit when I do the labels appears on every column.

Please let me know if it is clear or you need more clarifications.

DM
9 Replies
sunny_talwar

Are you saying that when you use this, it works?

Sum({<QuestionNumber = {'30','32'}>} msrAnswerCount)

/

Sum({<QuestionNumber = {'30','32'}>} msrAnswerCount).

But this should always give you 1, right?

Denis_L
Contributor III
Contributor III
Author

Hi Sunny,

Yes that is right, but when I add <total> function the labels appears on every column title.

DM
sunny_talwar

I am confused, you want 100% or you don't want 100%? Can you elaborate as to what you want?

Denis_L
Contributor III
Contributor III
Author

The problem is not in calculation.

The result is fine my problem is with Total Labels Titles

Please see the highlighted area of two images:

I get this:

total labels1.PNG

But I want this:

Totallabel2.PNG

Hope this explains

DM
sunny_talwar

Oh, I see... may be omarbensalem‌ have ideas...

Denis_L
Contributor III
Contributor III
Author

OK, Omar or somebody else can you help me with that

DM
Anil_Babu_Samineni

Have you attach your qvf file to test?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pablolabbe
Luminary Alumni
Luminary Alumni

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Denis_L
Contributor III
Contributor III
Author

Hi Pablo,

Thanks for a note.

There was no helpful or correct answer.

I am still waiting if somebody can answer my question.

When I receive correct or helpful answer I will definitely mark it is.

Thanks

DM