topic Re: RE:Exact colur in QlikView

RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 10:46:51 GMT

Hi all,

I have some issue on colur coding. below is my code for colurs

count(if(Prod_Severity = '1-Critical' or Prod_Severity = '2-Major',Prod_Defect_ID))

) * 100 < 95, rgb(255,0,0),

but am getting for 100% its shwng amber without any selections.

and if i do any selection that value is 100% and colur shwng as green?

how come is there any issue in the exp?

Thanks in advance.

Re: RE:Exact colur

sunny_talwar — Tue, 08 Mar 2016 10:52:13 GMT

1st of all, I would suggest you change the if statements to set analysis. I still don't know what might be causing it, but changing to set analysis will clear out some clutter here:

Count({<Prod_Severity = {'1-Critical', '2-Major'} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 11:01:43 GMT

shwng expression error sunny.

Re: RE:Exact colur

sunny_talwar — Tue, 08 Mar 2016 11:02:56 GMT

Sorry, I missed the missing set analysis syntax:

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 11:04:52 GMT

Hmmm..Still it is shwng error in expression?

Re: RE:Exact colur

sunny_talwar — Tue, 08 Mar 2016 11:06:14 GMT

Missed the if statement

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

If(Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 11:38:41 GMT

still same issue.........sunny

Re: RE:Exact colur

sunny_talwar — Tue, 08 Mar 2016 11:42:30 GMT

Really? that is embarrassing? Your original expression worked as you would expect without errors?

Re: RE:Exact colur

Anonymous — Tue, 08 Mar 2016 11:45:27 GMT

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 95, RGB(255,0,0),

Count({<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) * 100 < 100, RGB(255,200,10), Green()))

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 11:54:48 GMT

original exp wrkng fyn but the colurs not givng exctly...

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 11:55:10 GMT

sudhakar,

its givng error aftr "," comma

Re: RE:Exact colur

brijesh1991 — Tue, 08 Mar 2016 11:55:21 GMT

If(

Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) < 0.95, RGB(255,0,0),

if(

(Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) >= 0.95

and

Count({$<Prod_Severity = {'1-Critical', '2-Major'}>} Prod_Defect_ID) < 1), RGB(255,200,10), Green())))

Please add/ remove any brackets I missed here!! Writting directly here.

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 12:03:34 GMT

No luck

Re: RE:Exact colur

sunny_talwar — Tue, 08 Mar 2016 12:05:10 GMT

Would you be able to provide a sample?

Re: RE:Exact colur

Chanty4u — Tue, 08 Mar 2016 12:11:24 GMT

hi sunny,

i hve edited my thread with complete expression which is used in text object.

in font tab i hve given abve expression.