Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Totals Label

Hi Everyone,

This is probably simpler than I'm making it, but I'm stumped:

On a pivot table, Presentation tab > Show Partial Sums > Label for Totals, what's the most simplified method for including the dimensional value in the Total label? For instance, if the column is Product Category, and the dimension value is Clothing, how could the Label for Totals be made to says something like "Clothing Total"?

Thanks,

DJ

13 Replies
erichshiino
Partner - Master
Partner - Master

Actually, for a pivot table you can write on 'Label for Total' for each dimension that you enable for totals

mov
Employee
Employee

Erich,
6 points for trying... 🙂
Apparently the question was a little different. You can write lable 'Product Category', but what DJ wants is ="Product Category", so each value has it's own label. Although it is allowed to use expression here, it works only for the overall selected data, not for the table row. Not sure there is a solution.
Will follow, maybe there is...

Not applicable
Author

Exactly. And, I've tried loading a variable, but the string only works when the variable is a single value -- which effectively makes it behave like it's hard-coded. Not explicitly selecting a value, or selecting multiple values makes the string parse to NULL. 😞

agigliotti
Partner - Master III
Partner - Master III

Hello,

I need the same thing.  is there a way to achieve it in pivot table ?

azimabadi
Creator III
Creator III

HI everybody,

I have many times this problem and couldn't find any solution. today i have a new request that is the same and i tought to search in forum, maybe somebody has it already solved, but it seems that it's impossible

Not applicable
Author

Dear all,

I've also received the same request from two parties, may I know if anyone has solved this problem?

Any plan to support this?

Ivan

Gysbert_Wassenaar

See here


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks for your reply.  But what my client requested are the label to be dynamically changed based on the values of the previous column, such as the "Clothing Total" shown in the first post.

mountaindude
Luminary Alumni
Luminary Alumni

Any luck finding a solution for this?

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!