How to hide partial totals in using Layout-> Show conditional

[#1]

Hi, I have a QlikView Sheet with several levels and partial totals, but some of these totals are repetitive with a "PARTIAL TOTAL" title. I need to hide all the lines that have this title, example:

------

------

OTHER PRODUCTS 3,456.00

TOTAL 3,456.00

PARTIAL TOTAL 3,456.00 (this is the one I want to hide)

TOTAL PRODUCTS AND INCOMES 10,345.00

Thanks in advance!!,

John

[vgutkovsky · Accepted solution]

John,

I don't think you can hide it using the Layout menu. Why don't you just deselect Partial Sums for that level that you want to hide? It's on the Presentation tab.

Regards,

[#3]

Thanks for your help, but I need the totals because they acumulate previous values for the next level of totals, maybe the approach I did using QlikView only functions was not correct and could be solved with SQL grouping functions or QlikVIew aggregate.

Example:

GROUP OF ITEMS A ----- AMOUNT

TOTAL OF GROUP A ----- TOTAL

GROUP OF ITEMS B ------ TOTAL

TOTAL OF GROUP B ---- TOTAL

TOTAL OF GROUP A & B ------ TOTAL

GROUP C ------- TOTAL

......

TOTAL OF GROUP A & B & C ---- TOTAL

---- etc

Regards,

John

[vgutkovsky]

I'm having some trouble visualizing your layout. If you post a reduced & scrambled version, I can take a quick look.

Regards,