Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bhavvibudagam
Contributor 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
MVP
MVP

Re: Straight Table

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
MVP
MVP

Re: Straight Table

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

MVP
MVP

Re: Straight Table

Please don't create duplicate posts.

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

Re: Straight Table

Hi,


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



Thanks,

Venkata Sreekanth