Discussion Board for collaboration on QlikView Layout & Visualizations.
i've a table with 2 dimensions (one of these is a value list whit three kpi), and I have to put a total which sum the KPIs.
It's possible have a total when there is a value list?
in this moment i've this:
and i want to put, in the same table, a total like this:
Someone knows if it's possible?
Thank you very much!
Go to Solution.
Added a Inline table:
LOAD * Inline [
and change your first dimension to this:
=Pick(Dim, COMMODITY_SHORT_DESC, 'TOTAL')
and sort by expression -> COMMODITY_SHORT_DESC
Create a new field in the script for use as dimension in your pivot table. Add each
dual(Commodity,RecNo()) as ReportCommodity,
Commodity as Commodity
dual('Total', FieldValueCount('Commodity')+1) as ReportCommodity,
FieldValue('Commodity',RecNo()) as Commodity
Use ReportCommodity as dimension instead of Commodity in your pivot table. If you sort ReportCommodity numerically ascending the new Total value will be last.
It's exactly what i need!
Thank you very much!!
Thank you very much.
If your question is now answered, please flag the Correct Answer (by clicking on Correct Answer).
If not, please make clear what part of this topic you still need help with .