Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Expression

=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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi

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

but varchar field can filtered through = symbol


View solution in original post

7 Replies
Highlighted
Partner
Partner

Try like this:

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

Hope this helps you.

Regards,

Manideep

Highlighted
Partner
Partner

Hi

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.

Highlighted
Not applicable

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?

Highlighted
Not applicable

PCI-OP_name is varchar

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

Highlighted
Not applicable

What values exist in your field?

Highlighted
Partner
Partner

Hi

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

but varchar field can filtered through = symbol


View solution in original post

Highlighted
Not applicable

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)