partial expanded

[Anonymous]

hi,

Is it possible to have always an partial expanded in some columns in a pivot chart?

in attach i'll send you a small app example .

i wan't allways type expand , if not, i got wrong totals (sum of cost+revenue+result).

i don't want this:

i wan't this :

any help ?

thanks in advance

Ricardo

[sunny_talwar]

You want the second screenshot or third one?

[Anonymous]

both.

the user will chose to drill/ or not till CCost. but the values are ok.

"Type" must be allways expand.

first Screenshot his wrong.

[sunny_talwar]

I guess it depends on how you have saved your file (I think)... if it is saved with Company expanded, I think it should open like that?

[Anonymous]

but the user can collapse the "Type" and get wrong values.

I want avoid that.

[sunny_talwar]

Oh I see what you mean... may be possible with Macros, but QlikView doesn't have inbuilt capability to do this