Problem Regarding set analysis Expression

[#1]

Hi All,

The below expression is not working ...i want to list the last-name except whoes last name starts with  "S" along with salary in chart...

{<  LAST_NAME ={"*"}  - {"S*"}  >}

Please help if any correction !!!!!!!!

Sarfaraz

[alexandros17]

The syntax is correct, obviously you sent only a part of the whole expression, if it doesn't work check data, is there the problem

[ychaitanya]

Try this

{<Last_name - = {"S*"}>}

Thanks

Chaitanya

[qlikconsultant]

Try this:

{<  LAST_NAME <>{"*S"}>}

[alexandros17]

A thing you can try is :

replace " with '

Let me know

[maxgro]

add some aggregation function to your expression, it works

example

sum( {<  LAST_NAME ={"*"}  - {"S*"}  >} SALARY)

[#7]

I tried .....No not working........

below attached screenshot will help you to understand the problem ....

Sarfaraz

[alexandros17]

The correct and complete expression is:

Sum( {<  LAST_NAME ={"*"}  - {"S*"}  >} Salary)

Let me know

[sakamsureshbabu]

hi

you use this two exp

Sum( {<  LAST_NAME ={"*"}  - {"S*"}  >} Salary)  and

Sum( {<  LAST_NAME ={'*'}  - {'S*'}  >} Salary)

[#10]

In my case not working .....i am getting 0 in output as total and apart from this nothing is appear in the chart ....

The same expression i have tried what you wrote above ...i dont know what happening exactly ........

sarfaraz