topic Re: RE:what wrong in my expression? in QlikView

RE:what wrong in my expression?

Chanty4u — Mon, 21 Dec 2015 12:17:16 GMT

Hi all,

=Count({[Def_Severity]<='1-Critical'>Def_Id)

What wrng in dis exp?

any suggestions

Re: RE:what wrong in my expression?

Anonymous — Mon, 21 Dec 2015 12:21:01 GMT

try this

=Count({[Def_Severity]={'<=$(1-Critical')}>Def_Id)

Re: RE:what wrong in my expression?

Kushal_Chawda — Mon, 21 Dec 2015 12:21:41 GMT

try

Count({<[Def_Severity]={'1-Critical'}>}Def_Id)

Re: RE:what wrong in my expression?

Peter_Cammaert — Mon, 21 Dec 2015 12:30:02 GMT

Well, this is simple. Set modifiers are assignments, not comparisons. On the left, you specify a field name (no expressions, just a field name), then comes the assignment operator and then comes the set of values between curly braces you want to assign to that field

If you want to express the set of values as an expression ("all values smaller than or equal to"), you have to enter a search string between the curly braces. Rudolf did exactly that in correcting your example.

However, I don't exactly see what you mean by the comparison <= '1-Ciritcal'. Do you want to create set with all values that are smaller than or equal to 1 minus the value of field Critical? If not, then please specify what the values are that Def_Severity (square brackets aren't needed here) can have.

Re: RE:what wrong in my expression?

Chanty4u — Mon, 21 Dec 2015 12:30:43 GMT

hi kush,

i hve other filter lik

DEF_Aging

>3days

1day

2day

3day

but i need to disaply the colurs in same text object

=Count({<[Def_Severity]={'1-Critical'}>}Def_ID) in dis expression only

Median Value:
For Critical Defects : < 0.5 days - green, > 0.5 days to 1 day Yellow, > 1 day RED

For Major Defects : < 1.5 days - green, > 1.5 days to 3 days Yellow, > 3 days RED

Re: RE:what wrong in my expression?

Chanty4u — Mon, 21 Dec 2015 12:55:36 GMT

hi kush,

='Critical:-'&Count({<[Def_Severity]={'1-Critical'}>}Def_ID) and

if(count(Def_Severity)<=0.5, Red())

i hve tried bur expression sayng ok..but value colur nt chnging

Re: RE:what wrong in my expression?

Peter_Cammaert — Mon, 21 Dec 2015 12:58:16 GMT

You'll have to add the same set analysis in the second count as well, if you want to color a value relaled to '1-Ciritcal'. For example, add this to the Background Color expression:

=IF (Median({<[Def_Severity]={'1-Critical'}>} Defect_Aging_Days)<=0.5, Green(),

IF (Median({<[Def_Severity]={'1-Critical'}>} Defect_Aging_Days) > , Red(),

Yellow()))

Best,

Peter

[Edit] Modified to include correct field name from post below.

Re: RE:what wrong in my expression?

sunny_talwar — Mon, 21 Dec 2015 12:59:23 GMT

Can you share some data to help you better here?

Re: RE:what wrong in my expression?

Chanty4u — Mon, 21 Dec 2015 13:03:39 GMT

could u help sunny on this exp

='Critical:-'&Count({<[Def_Severity]={'1-Critical'}>}Def_ID) and

if(count(Defect_Aging_Days)<=0.5, Red())

Re: RE:what wrong in my expression?

Peter_Cammaert — Mon, 21 Dec 2015 13:06:52 GMT

Hmm, a count that returns 0.5? 0.4? 0.6 maybe?

Re: RE:what wrong in my expression?

sunny_talwar — Mon, 21 Dec 2015 13:07:54 GMT

Can you explain in words what are you trying to accomplish here? You are using text and some conditions to set color? Is this used in a chart or a text box object?? or is this for background color?

Re: RE:what wrong in my expression?

sunny_talwar — Mon, 21 Dec 2015 13:08:23 GMT

Re: RE:what wrong in my expression?

Chanty4u — Mon, 21 Dec 2015 13:17:42 GMT

i hve text object... wheever i am selecting one value frm def aging.... in tht text box the values colour shud be chnge based on values

Re: RE:what wrong in my expression?

Peter_Cammaert — Mon, 21 Dec 2015 13:22:25 GMT

You can either color the entire text box (see Properties->General->Background color button) or color the text itself (see Properties->Font->Text color button).Each button provides access to a color expression field (on the right)

You can enter my previous expression in either one or in both (making the text invisible, nah, not good).

Best,

Peter