How to show dimension with 'random' description?

heij1421 — Fri, 16 Dec 2016 10:54:52 GMT

Hi All,

I have a simple question, but I can't figure it out.

I have the following data

Code, Description, Amount

10, Description10, 100

10, Desription10, 200

20, Description 20, 300

20, DESCRIPTION 20, 400

Now I have a simple table with dimension 'Code' and expression SUM(Amount)

So far so good

Now I don't want to only display the Code, but also one of the descriptions. As you can see there are typos in the source data (desription instead of description). So when My dimension is Code and the second dimension is Description, than I have 4 rows instead of 2.

I want to group on Code and display one of the descriptions behind the code within that dimension.

I tried as dimension AGGR(Description,Code) but that doesn't work.

Thanks for helping.

Re: How to show dimension with 'random' description?

Gysbert_Wassenaar — Fri, 16 Dec 2016 10:59:26 GMT

Try AGGR(MaxString(Description),Code)

Or if you already use Code as dimension use an expression MaxString(Description) instead of using a calculating dimension

Re: How to show dimension with 'random' description?

heij1421 — Fri, 16 Dec 2016 11:29:56 GMT

Thanks Gysbert. The maxstring did the trick!

topic How to show dimension with 'random' description? in QlikView

How to show dimension with 'random' description?

Re: How to show dimension with 'random' description?

Re: How to show dimension with 'random' description?