Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have lots of customers (Customer ID) that have orders under a department e.g catering, finally and sub specialties (plates)
I have a pivot table showing number of sales per month for year (2014) for each department, which you can expand to show the sub specialties, number of sales
I would like to add a grand total column along the bottom for each month for each specialty
is this possible in qlik sense?
Go to Solution.
Not sure its possible in Qlik Sense pivottables - although I am keen to be corrected!
Only thing I can think to mimic it, is a normal table with static fields such as:
then use a drill down Dimension to get Department>Sub-specialty etc.
It won't look the same as your pivottable, but might be sufficient
Is this your after?
JS Pivot Table for QlikSense
would like to use expression, as some extensions are not supported on future updates
here is a picture from a previous post. I need to find out the expression how to get the BOTTOM total lines for each month
e.g where it shows total '110'
and main total '150'
Is this for Qlik Sense?
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
the extension format is exactly what I need, but I am steering away from using extensions
please can the Qlik team develop the total bar for the current pivot table contained within qlik sense
I took on Board your idea, but I found best using a bar chart
thank you Andrew x
Is it possible yet to generate a grand total line for measures in columns, for pivot tables? I see the answer above is from 2015, so I'm hoping things have changed since then.