Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
one solution could be to use a pivot table instead:
hope this helps
regards
Marco
Hi Marco,
I thought the pivot table needed values to work, with letters being involved I didn't think this would work.
Thanks
Chris
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
glad it helped.
please close your thread if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco