Sub total in pivot table

[Anonymous]

Hi

In the attached application ‘sales’ is  given a background color by comparing it with Goal1. But the Total which is displayed at the last must be compared against Goal 2 and given color. Qlikview generates the Total (By enabling the partial sum option). So I am not able to change the condition for background color of Total Column.

I tried by removing the partial sum and created a calculated dimension. It didn't work.

Could anyone help on this.

Thanks!

[Anonymous]

I am getting the background color but i have one more problem after implementing the above mentioned change.

i am getting a row like,

   
 
  which was not there before the change.

Could you please help me on this.

[Anonymous]

But when i remove the expression mentioned above i am nt getting any black row(like the one shown in the previous mesaage image)

[sunny_talwar]

So the qvw you posted up top was an example or was it the actual qvw you are working with? If it was an example, does the pivot table structure between your actual table and example table differs? Extra Dimensions? Extra expressions, anything is different like that????

[Anonymous]

Ya the one i posted is sample.

There is no difference between the two. Only the names of the dimensions and values vary.

[sunny_talwar]

Not sure, attaching the version you sent, may be you can figure what is different between the two versions. (PFA)

Best,

Sunny

[Anonymous]

ya sure i can.

Really thanks a lot for you help.

can you explain me the concept of dimensionality and column no with an example plz.

i was nt able to understand clearly from what i searched in net.

[sunny_talwar]

I can try to explain you, but I think there are good resources on community and it would be better to guide you towards those resources rather than trying to explain them again.

https://www.qlikcommunity.com/docs/DOC-8006

How to use - Dimensionality()

I am sure you will understand everything that you need to know about Dimensionality() and SecondaryDimensionality() as Robert_Mika has done a great job of explaining them with examples. If you still don't understand, I can def. try to help you with another example.

HTH

Best,

Sunny

[Anonymous]

Thanks a lot

[Anonymous]

Hi

The total row highlighted displays the Continent's total. But when i select a city say Delhi ,the total row is displaying Delhi's total alone. I expect it to display Asia's total even when a city is selected. Is there a way to implement that?

Could you please help me on that.

Also if a continent is selected i expect the above highlighted row to show the total of all the three continents.

Thanks!

[Anonymous]

Hi

The total row highlighted displays the Continent's total. But when i select a city say Delhi ,the total row is displaying Delhi's total alone. I expect it to display Asia's total even when a city is selected. Is there a way to implement that?

Could you please help me on that.

Also if a continent is selected i expect the above highlighted row to show the total of all the three continents.

Thanks!