topic Re: Unique value counter at the backend in QlikView

Unique value counter at the backend

bhaskarsharma03 — Thu, 17 May 2018 05:44:18 GMT

Hi,

I have Columns A and B (sorted). I wanted to have column C calculated and added to the table (at the backend) by the below logic:

- The value of C will start with 1 and will continue to increment until values in A are same, and the values in B are changing.

- After the value in A is changed, the value in C will again start with 1 and keep on increasing till the values in B are changing

Any help will be greatly appreciated.

Regards,

Bhaskar

jonathandienst — Thu, 17 May 2018 05:52:17 GMT

Like this

LOAD

If(A = Previous(A) And B <> Previous(B), Peek(C) +1, 1) as C

FROM ...

ORDER By A, B;

bhaskarsharma03 — Thu, 17 May 2018 05:55:54 GMT

the field C isn't there in the data, we need to create C with the given condition.

bhaskarsharma03 — Thu, 17 May 2018 06:01:00 GMT

Hi Jonathan,

Instead of Peek(C), Peek(C)+1 has worked.

LOAD

If(A = Previous(A) And B <> Previous(B), Peek(C) + 1, 1) as C

FROM ...

ORDER By A, B;

Thanks for the help.

Bhaskar