topic How to Hide a Repeating Dimension Row in QlikView

How to Hide a Repeating Dimension Row

Tue, 14 Jul 2015 10:25:39 GMT

Hi All,

I want a Distinct Row within the Field, and im struggling to get it right, please help

e.g

Field A	Values
0001	100
0001	250

output:

Field A	Header 2
0001	350

Thanks.

Re: How to Hide a Repeating Dimension Row

sunny_talwar — Tue, 14 Jul 2015 10:27:45 GMT

In the straight table object you can use Field A as your dimension and Sum(Values) as your expression.

Re: How to Hide a Repeating Dimension Row

lironbaram — Tue, 14 Jul 2015 10:27:55 GMT

create a straight table chart

use field A as dimension and create an expression sum(Values)

Re: How to Hide a Repeating Dimension Row

sunny_talwar — Tue, 14 Jul 2015 10:30:10 GMT

For script you can do this:

Table:

LOAD * Inline [

[Field A], Values

0001, 100

0001, 250

];

Join(Table)

LOAD [Field A],

Sum(Values) as TotalValues

Resident Table

Group By [Field A];

Create a table box with [Field A] and TotalValues to get the result you are looking for.

HTH

Best,

Sunny

Re: How to Hide a Repeating Dimension Row

Tue, 14 Jul 2015 10:33:02 GMT

Hi All,

your answers are correct, but if i want to hide a repeating Dimension as condition?

how do i do that?

Re: How to Hide a Repeating Dimension Row

phaneendra_kunc — Tue, 14 Jul 2015 10:33:21 GMT

First image is straight table chart output? or a table box?

If it is table box use a chart with FieldA as dimension and sum(Values) as expression and that will aggregate the result.

If it is a straight table and you still see two rows, one thing might be to do with the length/spaces in your Field A. use "trim([Field A]) while loading the script.