topic Re: How to group data by unique key and display only correlated data ? in QlikView

How to group data by unique key and display only correlated data ?

Fri, 20 Nov 2020 18:02:30 GMT

For example: Client has two account but client ID(account number) is same. I would like to hide client account number and only display name like second image. Also if client opens third account, Is it possible to add third account name and put them in order?

Re: How to group data by unique key and display only correlated data ?

jonathandienst — Tue, 29 Sep 2015 05:10:28 GMT

Create a list box using Name as a field. In the Sort tab, check the Expression option and use =[Account No] for the sort order. Or gave I misunderstood your (rather vague) requirements?

Re: How to group data by unique key and display only correlated data ?

jonathandienst — Tue, 29 Sep 2015 05:15:35 GMT

Re: How to group data by unique key and display only correlated data ?

Tue, 29 Sep 2015 18:48:51 GMT

Thank you. Is there a way to hide Account Column from the list box?

Re: How to group data by unique key and display only correlated data ?

avinashelite — Wed, 30 Sep 2015 04:51:50 GMT

are you talking about the list box or chart ? in list box you can have only one field at a time ..

if its in chart >straight table> go to chart properties >Presentation>select the field and check the hide option

Re: How to group data by unique key and display only correlated data ?

avinashelite — Wed, 30 Sep 2015 04:52:47 GMT