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

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

Thu, 19 Aug 2010 16:48:10 GMT

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

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

vgutkovsky — Thu, 19 Aug 2010 17:03:30 GMT

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,

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

Thu, 19 Aug 2010 17:49:12 GMT

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

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

vgutkovsky — Thu, 19 Aug 2010 18:02:10 GMT

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

Regards,