Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
How can i achieve this ?
Go to Solution.
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.
Were you able to figure out a solution to your problem?
I am facing the same issue.
You need to add Rowno() as RowNum as an extra field in your LOAD statement
That is similar to what I did to solve this issue. I pulled in an extra unique value field from DB to the report.
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:
Any way I can get onyl the highlighted rows to show up in my table?