topic Re: Question in QlikView

Question (show multiple descriptions)

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Need some help:

i have a column with article number and a column with a description.

It can be that an article have 2 different descriptions.

Is it possible to create a table that shows if there are 2 descriptions:

Article A description1

description2

Article L description1

description2

art. Nr	descr.
2000091733380	6201930000 6104630000
2000091733397	6207110000 6109100090

Re: Question

Anil_Babu_Samineni — Thu, 08 Jun 2017 15:19:54 GMT

I may not fully understand the intend, Would it possible to explain the result set you required. That may help us to think on fly

Re: Question

marcus_sommer — Thu, 08 Jun 2017 15:23:53 GMT

You could use [art. Nr] as dimension and count(distinct descr.) and concat(distinct descr., ' + ') as expressions in a table-cahrt and maybe also a calculated dimension within a listbox like: aggr(count(distinct descr.), [art. Nr]) to be able to filter them.

- Marcus

Re: Question

Peter_Cammaert — Thu, 08 Jun 2017 15:32:38 GMT

Or simply use a Table Box to list all active article nmubers and their linked descriptions.

Re: Question

Fri, 09 Jun 2017 07:16:49 GMT

Now I have :

if I expand all both description are visible:

But I want to see in the first Collapsed situation 2 or other ?? so I can find the double descriptions. It's a list with +50K records. So impossible to find everything just by scrolling.

Re: Question

Fri, 09 Jun 2017 12:54:46 GMT

Now I have :

if I expand all both description are visible:

But I want to see in the first Collapsed situation 2 or other ?? so I can find the double descriptions. It's a list with +50K records. So impossible to find everything just by scrolling.