Totals - Possible to show actual values - Qlik Community

matzas · ‎2010-07-20

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:

I want to:

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

Best regards

Mats

Report Inappropriate Content · ‎2010-07-20

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 · ‎2010-07-20

Thank you Sanchez!

With no joy? I am curious...

Report Inappropriate Content · ‎2010-07-20

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 · ‎2010-07-21

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

Report Inappropriate Content · ‎2010-07-21

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

matzas · ‎2010-07-21

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.