Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhuvan_agarwal1
New Contributor III

Find Consecutive?

Hi,

I am trying following:

Consecutive.png

Can Sombody help?

1 Solution

Accepted Solutions
MVP
MVP

Re: Find Consecutive?

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....

5 Replies
MVP
MVP

Re: Find Consecutive?

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....

bhuvan_agarwal1
New Contributor III

Re: Find Consecutive?

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.

MVP
MVP

Re: Find Consecutive?

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

bvssudhakar
Contributor

Re: Find Consecutive?

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

MVP
MVP

Re: Find Consecutive?

Hi Sudhakar,

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

Best regards

Petter

Community Browser