Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
Find below images
Can we achieve the second image.
Ignore the green rectangles , can we get the subtotals labels in the above way, in general we get a unique labels for eg total for all product values.
Thanks
Kiran Kumar
You can configure your label for Totals in Presentation tab (object settings)
Like this:
=[Product ID] & 'total'
The search box is your friend here. Spares you the time it takes to post a long question.
I found the following using a simple search: Showing Dynamic "Total Label"
HI
Only we can achieve like below link
https://community.qlik.com/message/251980#251980
And vote for this idea
Try this expression
If(Dimensionality() =1, ProductID& ' Total : ' & Sum(Sales),Sum(Sales))
and tick the check box of Show Partial sums for SalesmanID and give Space for "Labels For Totals".
Thanks all,
But none of all options are working. I am attaching a sample.
Thanks
Kiran Kumar
PFA
Thanks Kavitha for taking time but this way doesn't work for me as I have 4 dimension and two of them are pivoted.
Any other work arounds you suggest.
Thanks
Kiran Kumar
Okay..send the sample qvw as per ur requirement.
The requirement is just like the second pic in my original post above .Don't mind its customers data I cannot upload any file.
Thanks
Kiran Kumar