Discussion board where members can get started with QlikView.
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 want to:
I guess i can do something under "Presentation", but how?
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
this makes the country Bold.
then go to the Cities and change the label to 'City/Country'
hope this helps
Thank you Sanchez!
With no joy? I am curious...
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, SalesFROM ABC.xlsx (ooxml, embedded labels, table is Sheet1) where City <> 'Total';
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.
Are you looking for something like this which exports as under:
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.