Solved: Re: QLIKVIEW ISSUE - Qlik Community

mohanrao123 · ‎2020-09-04

Hi ALL,

I have attached sample data any one please help me.

YearQuater1=if sum(value)=0,last quarter where the sum(Value)<>0

Thanks,

Mohanrao

chrismarlow · ‎2020-09-04

Hi,

This is going to be very sensitive to your data model, so wouldn't be surprised if the below does not work for you (& as @rushikale0106 suggests more context will help), but you can try;

rangemaxstring(above(if(Value<>0,YearQuater),0,RowNo()))

I get below on a toy application (I've not tried to get the data exact);

Cheers,

Chris.

View solution in original post

rushikale0106 · ‎2020-09-04

Hi @mohanrao123 ,

Can you please explain this question again? What exactly you want to do with it?

Regards,

Rushi

chrismarlow · ‎2020-09-04

Hi,

This is going to be very sensitive to your data model, so wouldn't be surprised if the below does not work for you (& as @rushikale0106 suggests more context will help), but you can try;

rangemaxstring(above(if(Value<>0,YearQuater),0,RowNo()))

I get below on a toy application (I've not tried to get the data exact);

Cheers,

Chris.