QLIKVIEW ISSUE

[mohanrao123]

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

[rushikale0106]

Hi @mohanrao123 ,

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

Regards,

Rushi

[chrismarlow · Accepted solution]

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.