Formating pivot chart

[sergio0592]

Hi all,

I have  two dimensions (country and city) and one expression (sales). What i'am trying to,achieve is the output below (made on Excel).

l can't remember if it's possible with Qlikview. I think it could be esay if we can hide dimension in pivot chart. But we can't

For the moment i get the following chart :

Thanks

[chrismarlow]

Hi,

You can get close checking 'Indent Mode' on Style tab & changing the Country dimension to a calculated dimension 'Total ' & Country.

Interested to see if any better suggestions.

Cheers,

Chris.

[sunny_talwar · Accepted solution]

Something like this?

To do this, I created an island table like this in the script

Table:
LOAD * INLINE [
    Country, City, Sales
    France, Nice, 789
    France, Toulouse, 345
    Italy, Milano, 799
    Italy, Roma, 490
    Italy, Turino, 634
    UK, Liverpool, 457
    UK, London, 678
    UK, Manchester, 450
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

Now create a straight table like this

Dimension

=Pick(Dim, City, 'Total ' & Country)

Expression

Sum(Sales)

and sort the dimension using this

(Rank(Country)) + Dim/10

Use this for background color of expression and dimension

=If(Dim = 2, Yellow())

and use this for text formatting

=If(Dim = 2,'<b>')

[m_woolf]

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dimensionality/ta-p/1485559

[sergio0592]

It works, great Sunny as usual . Even if i can't understand how the link is made between contry and value 2 of the dim table.

[manoranjan_321988]

can u pls explain the (Rank(Country)) + Dim/10 

[sunny_talwar]

Add the above as an expression and you will understand what i was trying to do )

[manoranjan_321988]

i agree that it will make sort, but i can't understand,

rank(country) will be 1 2 3

but why adding with DIM/10 can explain deeply pls

example 

[sunny_talwar]

I have no problem in doing so, but if I do, then you will not have a chance to learn on how to break expressions and understand what they are doing.

Hint: Break the expression and see what it is doing
1) (Rank(Country)) + Dim/10
2) (Rank(Country))
3) Dim/10

and see there values 🙂