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

[#2]

not working getting 0 in the output ..........

Sarfraz

[maxgro]

could you post your Qlik doc?

[#4]

not working mr. suresh ...............please check

sarfaraz

[jyothish8807]

Hi Sarfaraz,

Do trim(Laste name) as [Last name] in the script.

Then try:

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

Regards

KC

[mr_novice]

Nothing wrong with the expressions if you add an aggregation function like Sum(). Maybe you are using it wrong? Attach you document to get more help.

[#7]

please check with beklow attached qvw file ..........

Sarfaraz

[#8]

Please check with the below attach file ......and help me ...

Sarfaraz

[maxgro]

field name are case sensitive

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

[mr_novice]

You need to spell Salary exactly as you field name: SALARY

[#11]

Thanks a lot guysss for helping me at all ......Now it is working fine as expected ........

Sarfaraz