Discussion Board for collaboration related to QlikView App Development.
I have data like custdids , date, sales and Prdids so on.., this one custids may be repeated or may not in last three months if repeated we need to count how many times it is repeating.
based on above senario we need to display one custid how many times repeated in last three months.
Data is like below:
Output like below:
Go to Solution.
Please use the below script
load *,1 as Count;
Load * inline [
Load CustID,Date,Sales,ProdID,if(CustID=Previous(CustID),Peek('Count')+1,Count) as Count Resident Test
Order by CustID;
DROP table Test;
It is more help full, Thank you once again.