Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
mohanrao123
Contributor
Contributor

QLIKVIEW ISSUE

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

 

 

 

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

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);

20200904_1.png

Cheers,

Chris.

View solution in original post

2 Replies
rushikale0106
Contributor III
Contributor III

Hi @mohanrao123 ,

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

Regards,

Rushi

chrismarlow
Specialist II
Specialist II

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);

20200904_1.png

Cheers,

Chris.