Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
rajeshqvd
Contributor II

Re: Finding Cycles

Please change RowNum 13,14,15 'Data' value as 'AB' you can get to know

Thanks,

Re: Finding Cycles

Why would it not increment to cycle4? Seems like the logic is always incrementing by 1 if there is AB on the previous row. This look like a special scenario and providing a fix for this might break other places...

rajeshqvd
Contributor II

Re: Finding Cycles

right i think you got my point..... is there any solution for this

Re: Finding Cycles

There might be, but like I said it might break other places... what is so unique about this example which makes you into increment by 1 after AB on the previous row? what if the data was like this?

    222, AB
    222, AB
    222, AB
    222, AB
    222, e

or this

    222, AB
    222, AB
    222, AB
    222, AB
    222, AB

There are 1000 possibilities that could happen, how do we find the anomalies?

rajeshqvd
Contributor II

Re: Finding Cycles

Where ever AB that should be return Cycle count and below rows return above AB Cycle count

222, AB,1
222,AB,2
222,sd,2
222,eff,2
and
222,AB,1
222,mm,1
222,kj,1
222,AB,2
222,kkjj,2
222,km,2

Re: Finding Cycles

So, then this is wrong?

image.png

Row 5 should be 2 then, right?

rajeshqvd
Contributor II

Re: Finding Cycles

No that is right try below data
ID,Data,Required Output
222,AB,1
222,AB,2
222,kkjj,2
222,km,2
222,ghg,2

Re: Finding Cycles

I am not sure I follow. May be someone else might be able to help you here.