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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
In Qliksense, i have a pivot table as attached.I want to show the Totals as a separate column after 'North' column where Total of:
Forecast: Sum for every zone i.e. Central, East and North
Last Day Sales: Sum for every zone i.e. Central, East and North
Var: Sum for every zone i.e. Central, East and North
How can i achieve this? When i checked the "Totals" at dimension level, it is showing me Totals at horizontal level(Bold in the image attached.)
You can Enable Total function in the SBUNAME Column.
It will show the 'Total' as first column before Central column.
View solution in original post
Another way for custom total
Load Distinct Zone, Zone as Zone1, resident table;
Load Distinct Zone, 'Total' as Zone1 resident table;
then use Zone1 in your pivot table.
if you enable "Show totals" under your dimension (must be the first one), you should achieve it.