topic Table Filter Dimenision in QlikView

Table Filter Dimenision

Anonymous — Mon, 16 Jan 2017 16:08:46 GMT

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

Re: Table Filter Dimenision

MarcoWedel — Mon, 16 Jan 2017 21:23:14 GMT

Hi,

one solution could be to use a pivot table instead:

hope this helps

regards

Marco

Re: Table Filter Dimenision

Anonymous — Mon, 16 Jan 2017 21:26:19 GMT

Hi Marco,

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

Thanks

Chris

Re: Table Filter Dimenision

MarcoWedel — Mon, 16 Jan 2017 21:31:24 GMT

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

Re: Table Filter Dimenision

MarcoWedel — Thu, 19 Jan 2017 23:04:31 GMT

‌glad it helped.

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco