Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Please find below the screenshot of an excel file example:
Column B is the ID, Column C is the count of ID (calculated as "=countif(B:B,B3)") and Column D is the weights (calculated as "1/Column C).
When i load ID in the qlikview, it only shows unique ID and not duplicate rows. I want to make Column C and Column D in qlikview. Appreciate the help and guide. Thanks I'm attaching the excel file also.
Use below script
Load *, RowNo() as NO Inline
[
ID
A
B
C
C
C
D
A
E
];
Now create a Straight Table
Dimension
NO
ID
Expression
1) COUNT(TOTAL <ID> ID)
2) COUNT(ID)/COUNT(TOTAL <ID> ID)
Use below script
Load *, RowNo() as NO Inline
[
ID
A
B
C
C
C
D
A
E
];
Now create a Straight Table
Dimension
NO
ID
Expression
1) COUNT(TOTAL <ID> ID)
2) COUNT(ID)/COUNT(TOTAL <ID> ID)
Thanks Manish. Your solution worked.
Regards,