Is there a way to create table like this on Qlikview.
I need to be able to show the count Total and % Total of this table [i.e. the last two rows]. Is this achievable?
|Week 1||Week 2||Week 3||Grand Total|
|Grand Total [%]||25%||33%||42%||100 %|
Hi this is exactly what I am looking for.
Can you explain the purpose of "dim". I don't have this value and can't figure out why you have included this in your expressions.
Dim is created as an Inline table and is not connected to anything in your database... This is basically used to create the two Grand Total rows
Pick(Dim, Name, 'Grand Total', 'Grand Total [%]')
So, when Dim = 1, Dimension is Name
when Dim = 2, Dimension is 'Grand Total'
when Dim = 3, Dimension is 'Grand Total [%]'
I already tested it in an application.
I used as pick as separated expressions... There is a lot of difference.(But I don't know explain the reasons why kkkk)
"Also, what happens if you select a single name here? Emily... would the total % go up or down"
-The total field don't move