topic Re: Straight Table in QlikView

Straight Table

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below requirement.

I have Two fields named Name and Value taken in below straight Table

Here the Name field contains the Number of records like Change Type, Systems, Issues.. etc and each type in name field contains set of Values in the Value field.

In another report I have to show each Record in Name field and Corresponding values as separate columns like, in a table first column

is Change Type Column with values and second column like system with values.

Thanks in advance.

Re: Straight Table

jonathandienst — Wed, 14 Mar 2018 05:51:02 GMT

Simplest way is to use a pair of list boxes with calculated fields:

Aggr(Only({<Name = {'Change Type'}>} Value), Value)

Aggr(Only({<Name = {'Systems'}>} Value), Value)

Re: Straight Table

jonathandienst — Wed, 14 Mar 2018 05:53:00 GMT

Please don't create duplicate posts.

Re: Straight Table

Anonymous — Wed, 14 Mar 2018 07:05:30 GMT

Hi,

Post the sample application. Si that everyone can understand the requirement clearly.

Thanks,

Venkata Sreekanth