Table Filter Dimenision

[Anonymous]

I want to be able to use one field twice in a table using an if statement or some sort of filtering.

The attached has an inline table as below and I want to be able to put the Y11-Pu1 alongside the Y11-Pu2.

I can filter out the first column to show Y11-Pu1 but when I try the same with Y11-Pu2 it shows nothing in the column (see sheet in attached)

Table:
Load * inline

[
Key,PU,Grade
1,Y11-Pu1,A
2,Y11-Pu1,C
3,Y11-Pu1,1
4,Y11-Pu1,4
5,Y11-Pu1,F
6,Y11-Pu1,G
7,Y11-Pu1,U
1,Y11-Pu2,B
2,Y11-Pu2,A
3,Y11-Pu2,2
4,Y11-Pu2,5
5,Y11-Pu2,A
6,Y11-Pu2,E
7,Y11-Pu2,G
];

Any help gratefully appreciated.

Chris

[MarcoWedel]

Hi,

one solution could be to use a pivot table instead:

hope this helps

regards

Marco

[Anonymous]

Hi Marco,

I thought the pivot table needed values to work, with letters being involved I didn't think this would work.

Thanks

Chris

[MarcoWedel]

another possibility might be a generic load:

Table:
Generic
Load * Inline
[
Key,PU,Grade
1,Y11-Pu1,A
2,Y11-Pu1,C
3,Y11-Pu1,1
4,Y11-Pu1,4
5,Y11-Pu1,F
6,Y11-Pu1,G
7,Y11-Pu1,U
1,Y11-Pu2,B
2,Y11-Pu2,A
3,Y11-Pu2,2
4,Y11-Pu2,5
5,Y11-Pu2,A
6,Y11-Pu2,E
7,Y11-Pu2,G
];

hope this helps

regards

Marco

[MarcoWedel]

‌glad it helped.

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco