Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Straight Table

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.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

Please don't create duplicate posts.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

Hi,


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



Thanks,

Venkata Sreekanth