topic Re: Need help with creating Syntax in QlikView

Need help with creating Syntax

Tue, 16 Dec 2014 21:24:17 GMT

Hello,

My name is Syed Q. I have started my carrier as a qlikview developer few months back. I have always looked up to the community if i needed any help all along. But today i need help with creating a syntax. I have searched all over the internet and in community but couldn't come up with an answer. I am trying to put up a syntax in which

"sum({<FINAL_STATUS_CODE={A,D}>}CLAIM_CNT)/sum(CLAIM_CNT)" is my expression for Approval rate. I want to use this approval rate to create column which will have two colors that will change based on if my approval rate is greater then the expression total then red color else green.

Can someone please help me creat a syntax wit this condition.

Thanks,

Syed

Re: Need help with creating Syntax

Tue, 16 Dec 2014 21:37:57 GMT

Hi,

You need to write an color expression for Background Color or Text Color area under your expression (click + sign next to your expression to see available options)

Then in Color expression you need to write something like:

=if(sum({<FINAL_STATUS_CODE={A,D}>}CLAIM_CNT)/sum(CLAIM_CNT) < sum({<FINAL_STATUS_CODE={A,D}>} TOTAL CLAIM_CNT)/sum(TOTAL CLAIM_CNT), LightRed())

if you have label for your expression you can refer it (assuming Approval Rate is the label for your expression:

=if([Approval Rate] < sum({<FINAL_STATUS_CODE={A,D}>} TOTAL CLAIM_CNT)/sum(TOTAL CLAIM_CNT), LightRed())

Re: Need help with creating Syntax

Tue, 16 Dec 2014 21:44:26 GMT

Thank you very much. That Solved it.

Re: Need help with creating Syntax

Thu, 18 Dec 2014 21:38:35 GMT

Hi Ersen,

One last question. How do i exclude the total itself from coloring. i have the condition wherein if > total red else green. because i have no condition for what if = total. So it colors the total green too.

I appreciate your help.

Thank you.

Re: Need help with creating Syntax

Thu, 18 Dec 2014 22:34:09 GMT

Hi Syed,

start your coloring expression:

if (Dimensionality()=0 or SecondaryDimensionality()=0, Null(),
if(Only(Group) = 1, $(vGreen),
if(Only(Group) = 3, $(vYellow),
if(Only(Group) = 5, $(vRed), Null())))
)