topic Re: Similar function to "CountIf" of Excel in QlikView

Similar function to "CountIf" of Excel

kash04kk — Wed, 13 Jan 2016 07:54:02 GMT

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.

Re: Similar function to "CountIf" of Excel

MK_QSL — Wed, 13 Jan 2016 09:26:08 GMT

Use below script

Load *, RowNo() as NO Inline

[

];

Now create a Straight Table

Dimension

Expression

1) COUNT(TOTAL <ID> ID)

2) COUNT(ID)/COUNT(TOTAL <ID> ID)

Re: Similar function to "CountIf" of Excel

kash04kk — Thu, 14 Jan 2016 10:03:58 GMT

Thanks Manish. Your solution worked.

Regards,