topic Re: Get the Max Value for Consecutive Periods in QlikView

Get the Max Value for Consecutive Periods

Wed, 09 Apr 2014 19:32:22 GMT

Hello,

I have a table with ids and periods. I need to get the max value for the column consecutive periods.

I created a column named consecutive periods, but now I need to get the max value for the field consecutive periods for each id.

The thing is that I can't use the max function because the column consecutive periods is an expression and it shows me null values.

What I need is to obtain a result like the following:

I should have something like this, hiding the columns periods and consecutive periods using a simple table graphic:

Notes:

I would need this as an expression in my table because the periods are dynamic and they vary according to a slider object.

Thanks for your help!

MK_QSL — Wed, 09 Apr 2014 19:46:29 GMT

Like This?

Wed, 09 Apr 2014 20:49:05 GMT

I would use that solution if I had fixed periods.

But as I asked before, I have something like this with a slider object that make the periods dynamic:

I attach the file with the slider object.

Thank you!

Thu, 10 Apr 2014 21:01:06 GMT

David,

I found 1 more issue in v1, so there is v2.

Please let me know if my demo gives you expected results.

I'am still trying to find more elegant way to calculate your indicator....

regards

Darek

Thu, 10 Apr 2014 22:47:54 GMT

You should use AGGR function and get the max.

Thu, 10 Apr 2014 22:59:01 GMT

Pushpendra,

of course you are right.

But there is problem of counting number of Consecutve periods before this max.

Please look on my demo. I think, it gives good results, but expression is not very elegant. Maybe you will find better way?

regards

Darek