topic Expression in QlikView

Expression

Thu, 20 Nov 2014 12:25:22 GMT

=sum({$<[PCI_Op_Name]={">=$(v_value)"}>}Direct_Cost) expresssion is ok butt on chart no value is displayed

v_value=10000

kindly check the expression

Re: Expression

manideep78 — Thu, 20 Nov 2014 12:30:10 GMT

Try like this:

Sum({<[PCI_Op_Name]={">=$(=v_value)"}>}Direct_Cost)

Hope this helps you.

Regards,

Manideep

Re: Expression

perumal_41 — Thu, 20 Nov 2014 12:32:18 GMT

i think expression is worng. PCI_Op_Name field is varchar or numeric ,if varchar [PCI_Op_Name]={">=$(v_value)"} expression won't work. only greater then or less then operator used for numeric values comparsion.

please explain what your trying achive thorugh expression. we can able to help.

Re: Expression

Thu, 20 Nov 2014 12:32:23 GMT

Is the the PCI_Op_Name a string value?

So for example.

PCI_Op_Name = Joe Bloggs

v_value = 10000

In your set analysis you are returning only Joe Bloggs (PCI_Op_Name) > 10000 which would return Null.

What are you trying to achieve?

Re: Expression

Thu, 20 Nov 2014 12:38:42 GMT

PCI-OP_name is varchar

when i am using = sign it works butt when i used >= sign it does not work

Re: Expression

Thu, 20 Nov 2014 12:51:11 GMT

What values exist in your field?

Re: Expression

perumal_41 — Thu, 20 Nov 2014 13:08:00 GMT

only can compare or filtered numerric through >= or <= symbol.

but varchar field can filtered through = symbol

Re: Expression

Thu, 20 Nov 2014 13:14:38 GMT

I am assuming that you have numeric and string values in the field.

So something like this should work

=Sum({<

PCI_Op_Name = {"=IsNum(PCI_Op_Name) =-1"} - {"<10000"}

>} Direct_Cost)