Discussion Board for collaboration related to Creating Analytics for QlikView.
Need a small help... I have a table as Below
I want the output as below...
I can get this Information whith the help of below formula in excel....
please help if can can do the same in Qlikview.
Thanks in advance...
Go to Solution.
First order the table based on the customer number and use Previous function to achieve that.
Order by CustomerNo;
If(Previous(CustomerNo)=CustomerNo, Peek('Transaction#') + 1, 1) As Transaction#
Drop Table Temp;
Hope it helps
Can you explain the logic to get the transaction#. sorry i am not good in excel functions
Thanks for the response...
I would like to explain the requirement...
Lets assume I have a Table...
Now my requirement in this table '111' is repeated twice in table...
So when 111 come first in the table, Transaction# will be 1, second time it will be 2, thrird time it will be 3 so on and so forth...
This logic should apply on all the values in 'Customer No.'
Thanks alot... it really helped..