topic Re: Straight Table Hide Rows but Show Totals and Subtotals in QlikView

Straight Table Hide Rows but Show Totals and Subtotals

Thu, 14 Feb 2013 18:08:12 GMT

Is there an easy way to hide row values but display the total in a Straight Table?

Example, I want to change this:

Name Value1 Value2

Joe 1 4

Sally 1 3

Fred 1 4

Total 1 11

To this Result:

Name Value1 Value2

Joe 4

Sally 3

Fred 4

Total 1 11

Re: Straight Table Hide Rows but Show Totals and Subtotals

Gysbert_Wassenaar — Thu, 14 Feb 2013 18:19:25 GMT

Something like this: if(dimensionality()=0,max(Value1),'')

Re: Straight Table Hide Rows but Show Totals and Subtotals

Tue, 26 Feb 2013 21:06:36 GMT

For most expressions this would work: Make a straight table with no dimension. There will be only one row.

If your original straight table had calculated dimensions and/or totals that are sum of rows totals then this method may not work for you.

I've seen people make the straight table as small as possible by sliding up the lower boundary and then covering up the unwanted portion with an opaque text box.