Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

Hello,

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!

1 Solution

Accepted Solutions
Highlighted

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

This?

Capture.PNG

Added a Inline table:

LOAD * Inline [

Dim

1

2

];

and change your first dimension to this:

=Pick(Dim, COMMODITY_SHORT_DESC, 'TOTAL')

and sort by expression -> COMMODITY_SHORT_DESC

5 Replies
MVP & Luminary
MVP & Luminary

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

Create a new field in the script for use as dimension in your pivot table. Add each

NewTable:

LOAD DISTINCT

     dual(Commodity,RecNo()) as ReportCommodity,

     Commodity as Commodity

RESIDENT

     ...source_table_that_contains_the_commodity_field...

ORDER BY

     Commodity

     ;


CONCATENATE (NewTable)

LOAD

     dual('Total', FieldValueCount('Commodity')+1) as ReportCommodity,

     FieldValue('Commodity',RecNo()) as Commodity

AUTOGENERATE FieldValueCount('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.


talk is cheap, supply exceeds demand
Highlighted

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

This?

Capture.PNG

Added a Inline table:

LOAD * Inline [

Dim

1

2

];

and change your first dimension to this:

=Pick(Dim, COMMODITY_SHORT_DESC, 'TOTAL')

and sort by expression -> COMMODITY_SHORT_DESC

Not applicable

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

It's exactly what i need!

Thank you very much!!

Not applicable

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

Thank you very much.

Silvia

oknotsen
Honored Contributor III

Re: TOTAL IN A CHART TABLE WITH VALUE LIST IN DIMENSION

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 .

May you live in interesting times!