Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView App Dev

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Who Me Too'd this solution

jerryyang756
Creator
Creator

Try this...exclude selections in SELECTION1=,SELECTION2=

if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='less Than 7' , '#66b699',
if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='7-10','#ffff4d',
if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='More Than 10', '#ff4d4d'
)))

or with {1} to exclude all selections

if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='less Than 7' , '#66b699',
if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='7-10','#ffff4d',
if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='More Than 10', '#ff4d4d'
)))

View solution in original post

Who Me Too'd this solution