This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have two dimensions, one as week, second as Name for a stacked bar chart.
I have one expression = count (distinct ID)
I want to display total of the count on axis.
I am getting multiple totals as its stacked.
Is there a way to get one single total of all the count
See attached picture. Where I have Date and Material as dimension and my expression is Sum([Stock-level]).
To get the grand total you need to add total <Date> to the new expression, Sum(TOTAL<Date>[Stock-level]). This will result in grand total per date (in your case week).
I want them displayed on "Text on Axis".