Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following problem:
I have a table with 3 colums named Opdracht,Relnr,Refnr.
The table is as following:
Opdracht Relnr Refnr
1 1 100
1 2 101
1 3 102
1 4 102
2 5 102
2 6 103
3 1 100
3 7 107
3 8 107
Here i want to show only the Rows where a 'Opdracht' has >1 of the same 'Refnr'
The result must show the following:
Opdracht Relnr Refnr
1 3 102
1 4 102
3 7 107
3 8 107
How can i achieve this ?
Thanks,
SY
You can use this expression in a table chart with dimensions Opdracht, Relnr, Refnr:
=if (aggr(NODISTINCT count(Refnr),Opdracht,Refnr)>1,1,0)
then hide the expression in presentation tab.
You can use this expression in a table chart with dimensions Opdracht, Relnr, Refnr:
=if (aggr(NODISTINCT count(Refnr),Opdracht,Refnr)>1,1,0)
then hide the expression in presentation tab.
Thanks! that worked.
hi, I have an excel file which has two identical rows. In backend, all the rows are being fetched but when i try to displcya the rows in a pivot table in frnt end then I am not able to see that identical rows. It is taking all as one entry.
Please help on this issue.
Varun Raj,
You need to add Rowno() as RowNum as an extra field in your LOAD statement
Thanks,
Singh
Hi Angad,
That is similar to what I did to solve this issue. I pulled in an extra unique value field from DB to the report.
Thanks,
Varun Raj
I am trying to apply this similar function to a table in my qlikview file, but it is not returning just the repeated values. My data is as follows:
ID | Modified_Date | Region | Product | Sales |
1 | 1/1/2016 | Midwest | CAR | $ 300.00 |
2 | 1/2/2016 | South | CAR | $ 300.00 |
2 | 1/11/2016 | West | CAR | $ 300.00 |
3 | 1/3/2016 | North | VAN | $ 500.00 |
4 | 1/4/2016 | South | TRUCK | $ 650.00 |
5 | 1/5/2016 | West | TRUCK | $ 650.00 |
6 | 1/6/2016 | Midwest | VAN | $ 500.00 |
7 | 1/7/2016 | West | TRUCK | $ 650.00 |
8 | 1/8/2016 | North | CAR | $ 300.00 |
9 | 1/9/2016 | North | CAR | $ 300.00 |
10 | 1/10/2016 | West | TRUCK | $ 650.00 |
11 | 1/11/2016 | Midwest | CAR | $ 300.00 |
12 | 1/12/2016 | South | VAN | $ 500.00 |
13 | 1/13/2016 | South | TRUCK | $ 650.00 |
14 | 1/14/2016 | West | VAN | $ 500.00 |
15 | 1/15/2016 | North | TRUCK | $ 650.00 |
16 | 1/16/2016 | West | CAR | $ 300.00 |
17 | 1/17/2016 | South | VAN | $ 500.00 |
18 | 1/18/2016 | North | CAR | $ 300.00 |
Any way I can get onyl the highlighted rows to show up in my table?
Thanks,
T