topic Re: Problem Regarding set analysis Expression in QlikView

Problem Regarding set analysis Expression

Fri, 17 Oct 2014 06:49:25 GMT

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

Re: Problem Regarding set analysis Expression

alexandros17 — Fri, 17 Oct 2014 06:54:23 GMT

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

Re: Problem Regarding set analysis Expression

ychaitanya — Fri, 17 Oct 2014 06:55:13 GMT

Try this

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

Thanks

Chaitanya

Re: Problem Regarding set analysis Expression

qlikconsultant — Fri, 17 Oct 2014 06:55:59 GMT

Try this:

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

Re: Problem Regarding set analysis Expression

alexandros17 — Fri, 17 Oct 2014 07:02:38 GMT

A thing you can try is :

replace " with '

Let me know

Re: Problem Regarding set analysis Expression

maxgro — Fri, 17 Oct 2014 07:13:37 GMT

add some aggregation function to your expression, it works

example

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

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:16:51 GMT

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

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

Sarfaraz

Re: Problem Regarding set analysis Expression

alexandros17 — Fri, 17 Oct 2014 07:19:23 GMT

The correct and complete expression is:

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

Let me know

Re: Problem Regarding set analysis Expression

sakamsureshbabu — Fri, 17 Oct 2014 07:23:57 GMT

you use this two exp

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

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

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:24:07 GMT

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

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:27:29 GMT

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

Sarfraz

Re: Problem Regarding set analysis Expression

maxgro — Fri, 17 Oct 2014 07:28:24 GMT

could you post your Qlik doc?

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:28:34 GMT

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

sarfaraz

Re: Problem Regarding set analysis Expression

jyothish8807 — Fri, 17 Oct 2014 07:33:07 GMT

Hi Sarfaraz,

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

Then try:

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

Regards

Re: Problem Regarding set analysis Expression

mr_novice — Fri, 17 Oct 2014 07:36:08 GMT

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.

Re: Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:36:19 GMT

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

Sarfaraz

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 07:42:03 GMT

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

Sarfaraz

Re: Problem Regarding set analysis Expression

maxgro — Fri, 17 Oct 2014 07:48:01 GMT

field name are case sensitive

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

Re: Problem Regarding set analysis Expression

mr_novice — Fri, 17 Oct 2014 07:51:49 GMT

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

Re: Problem Regarding set analysis Expression

Fri, 17 Oct 2014 09:09:49 GMT

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

Sarfaraz