Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
matzas
New Contributor III

Totals - Possible to show actual values

Hi

Is it possible to show the actual value for totals, and not only the text "Total"?

In that case how?

In the example below i want to replace the text "Total" in the City field, with values from the Country field:

I have:

CountryCitySales
USAChicagoxx
Jolietxx
New Yorkxx
Totalxx
SwedenAskimxx
Hjoxx
Stockholmxx
Totalxx
FranceArlesxx
Bayonnexx
Parisxx
Totalxx
Totalxx


I want to:

City/CountrySales
Chicagoxx
Jolietxx
New Yorkxx
USAxx
Askimxx
Hjoxx
Stockholmxx
Swedenxx
Arlesxx
Bayonnexx
Parisxx
Francexx
Totalxx


I guess i can do something under "Presentation", but how?

Best regards

Mats

6 Replies
Not applicable

Totals - Possible to show actual values

this has been posted before but with no joy.

heres the best solution i can come up with.

go to the style tab and check 'Indent Mode' Check Box.

then go to the dimensions tab and expand the primary dimension, in your case 'Country'.

double click on 'Text Format' and enter in the expresion box there

='<B>'

this makes the country Bold.

then go to the Cities and change the label to 'City/Country'

hope this helps

matzas
New Contributor III

Totals - Possible to show actual values

Thank you Sanchez!

With no joy? I am curious...

Not applicable

Totals - Possible to show actual values

Hi,

Perhaps not the best solution for your query but a work around what you can do is while loading exclude the data point Total.

The syntax while loading would be as under

Directory;
LOAD
Country,
City,
Sales
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1) where City <> 'Total';

matzas
New Contributor III

Totals - Possible to show actual values

Tank you Umang!

But i think you have misinterpreted the situation.

The files in my example is not something i want to load into QV. It is the output from QV.

I have to distribute statistcal reports from the tables in QV, and want to keep the manual work at a minimum.

Best regards

Not applicable

Totals - Possible to show actual values

Embarrassed

Are you looking for something like this which exports as under:

CountryCityExperience
FranceArles962.00
FranceBayonne496.02
FranceParis706.00
FranceTotal2,164.02
SwedenAskim923.18
SwedenHjo704.00
SwedenStockholm926.00
SwedenTotal2,553.18
USAChicago397.37
USAJoliet161.00
USANew York304.92
USATotal863.29
Total5,580.49
matzas
New Contributor III

Totals - Possible to show actual values

That is what i have today. I would like to replace all the values "Total" in the column City, with the corresponding value in the column Country.