Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Find Consecutive?

Hi,

I am trying following:

Consecutive.png

Can Sombody help?

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Here is a solution which shows how it can be done either mostly in the load script with very simple table expressions or entirely done in a table expression in one single example application:

2018-04-02 11_14_06-Reply to Find Consecutive_ _ Qlik Community.png

Use this load script for the first table:

2018-04-02 11_15_26-Qlik Sense Desktop.png

Use this load script for the second or third table:

2018-04-02 11_16_01-Reply to Find Consecutive_ _ Qlik Community.png

You can find the entire example application attached with the load scripts and tables....

View solution in original post

5 Replies
petter
Partner - Champion III
Partner - Champion III

Here is a solution which shows how it can be done either mostly in the load script with very simple table expressions or entirely done in a table expression in one single example application:

2018-04-02 11_14_06-Reply to Find Consecutive_ _ Qlik Community.png

Use this load script for the first table:

2018-04-02 11_15_26-Qlik Sense Desktop.png

Use this load script for the second or third table:

2018-04-02 11_16_01-Reply to Find Consecutive_ _ Qlik Community.png

You can find the entire example application attached with the load scripts and tables....

Anonymous
Not applicable
Author

Hi Petter,

That is what I wanted thanks a lot for your kind efforts, it will be great if you help me in the same but a bit different scenario actually the month/ID which is mentioned here is repetitive. The format is attached in a excel file here.

petter
Partner - Champion III
Partner - Champion III

Thanks, I will see if I can find time later today...

bvssudhakar
Creator III
Creator III

Hi Petter,

I have one requirement, here i attached one qvw file in that file

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

    

24222/16/2012Baby ClothesAino ShoesHalle KölnBob Park41
24222/16/2012Baby ClothesDeuce ShirtHalle KölnBob Park11
46651/21/2013Baby ClothesAino ShoesLa Moda d'il FuturiRicardo Gucci61
46651/21/2013Baby ClothesDeuce ShirtLa Moda d'il FuturiRicardo Gucci12

But output is not showing like this, it is showing selections related 572 rows some thing

Give some suggestions to out from this situation

Thank you in advance

Sudhakar

petter
Partner - Champion III
Partner - Champion III

Hi Sudhakar,

You should post this as a new question yourself - this is a thread that has already been answered.

Best regards

Petter