Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks
Jos
you can set colors here
i want to script logic by using the if condition but i don't write A to Z state names in the script like Provider state = :AK', 'Al' Like this
and i don't want to use the colour tab Persistent colors check box also
refer below link
http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/
Hi, Please check these links. Thank you. https://community.qlik.com/docs/DOC-8975 https://community.qlik.com/thread/178485
Hi,
go to the color tab-> and check on or check Multi colored
If(Sum({<[Provider State]={'AK','AL','AR','AZ'}>}, Red(),
If(Sum({<[Provider State]={'CA','CO','CT'}>},Blue(), Green())))AVERAGE TOTAL PAYMENT * TOTAL DISCHARGES)
I Write the Script like that but it show error
try
If(match([Provider State],'AK','AL','AR','AZ'), Red(),
If(match[Provider State],'CA','CO','CT'),Blue(), Green()))
hi josna,
expression tab: Sum([Average Total Payments]* [Total Discharges])
under expression -> background colour ->
give
If([Provider State]={'AK','AL','AR','AZ'}, Red(),
If([Provider State]={'CA','CO','CT'},Blue(), Green()))
or
If(match([Provider State],'AK','AL','AR','AZ'), Red(),
If(match[Provider State],'CA','CO','CT'),Blue(), Green()))
Regards
Neetha