Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
7 Replies
xyz1
Creator III
Creator III
Author

.

agigliotti
Partner - Champion
Partner - Champion

I think you should sort for date numerically asc first.

agigliotti
Partner - Champion
Partner - Champion

your expression looks good.

xyz1
Creator III
Creator III
Author

.

agigliotti
Partner - Champion
Partner - Champion

did you solve it?

xyz1
Creator III
Creator III
Author

.

agigliotti
Partner - Champion
Partner - Champion

maybe this:

=if(

Sum(

Aggr( AVG( {$< market={'DOMESTIC'}, [date.Calendar.MonthRelNo]={'0'}, [date.Calendar.Year]={'2018'}, im_descr-={'*SCRAP*'}, im_descr_limited_flag = {1} >} rate ), rate )

)

>

Sum(

Aggr( AVG( { $< market={'DOMESTIC'}, [date.Calendar.MonthRelNo]={'1'}, [date.Calendar.Year]={'2018'}, im_descr-={'*SCRAP*'}, im_descr_limited_flag = {1} >} rate ), rate )

)

, LightRed(), Green() )

and set Sorting by Month numerically ASC.

Otherwise simplest for color expression :

if( After( column(2) ) > column(2), RGB(201, 17, 62), green() )