Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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() )