Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You want the second screenshot or third one?
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.
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?
but the user can collapse the "Type" and get wrong values.
I want avoid that.
Oh I see what you mean... may be possible with Macros, but QlikView doesn't have inbuilt capability to do this