topic QLIKVIEW ISSUE in QlikView

QLIKVIEW ISSUE

mohanrao123 — Fri, 04 Sep 2020 09:07:43 GMT

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

Re: QLIKVIEW ISSUE

rushikale0106 — Fri, 04 Sep 2020 10:22:58 GMT

Hi @mohanrao123 ,

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

Regards,

Rushi

Re: QLIKVIEW ISSUE

chrismarlow — Fri, 04 Sep 2020 16:27:37 GMT

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.