Discussion Board for collaboration related to QlikView App Development.
I need your help for understand how to make a iteration table in qlikview.
For example, i have this table of data :
I need to theses 2 analisis tables :
Nb d'iteration : number of time "num client" appear.Nb num client : number of "num client" appear.
It is understandable ? Any Ideas ?
Thanks a lot 🙂
Hi i hope i understood your'e requirement upto an extent. Please check the following code :
LOAD * INLINE [
CODE, NUM_CLIENT, THEME
1, NUM1, Assistance
2, NUM1, Assistance
3, NUM2, Réclamation
4, NUM2, Réclamation
5, NUM2, Réclamation
6, NUM3, Résiliation
7, NUM4, Acte commercial
8, NUM4, Acte commercial
9, NUM5, Acte commercial
10, NUM5, Acte commercial
11, NUM5, Acte commercial
12, NUM5, Acte commercial
Count(NUM_CLIENT) as Nbnumclient
Resident Temp Group by NUM_CLIENT,THEME;
Load Nbnumclient,Concat(NUM_CLIENT,',') as Concat
Group By Nbnumclient;
DROP Table Temp;
//use Below for Iteration
//If(Peek(NUM_CLIENT)=NUM_CLIENT,Peek(nclient)+1,1) as nclient
//Resident Temp Order by CODE,NUM_CLIENT asc;
Also Find attached QVW for ref;
hi ! thanks, i will try this solution to tell you if i can result my case with it.