topic Re: Expression Problem in QlikView

Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 13:32:53 GMT

Quick Question, I have a simple Expression in a line chart. I wanted to modify it so it only showed a single Work Group so that I can display all of them on a single chart. Right not my expression works, but when I try to narrow it down to one group says the expression is ok, but no data.

current:

Sum(Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)/(Count(Phone#Identifier)*100)

New:

if([Work Type]='PPA',Sum(Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)/(Count(Phone#Identifier)*100))

I have attached a version of the report for reference.

Re: Expression Problem

anbu1984 — Fri, 12 Sep 2014 13:35:52 GMT

Try this

Sum(if([Work Type]='PPA',Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7))/(Count(Phone#Identifier)*100)

Re: Expression Problem

Fri, 12 Sep 2014 13:39:28 GMT

Hey there,

Have you tried this:

Sum({<[Work Type] ={"PPA"}>}Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)

Count({<[Work Type] ={"PPA"}>}Phone#Identifier)*100

Greetings Patrick

Re: Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 14:15:58 GMT

Did not work sorry

Re: Expression Problem

Fri, 12 Sep 2014 14:19:38 GMT

Could you provide a demo.qvw so i can try a little bit?

Re: Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 14:39:18 GMT

sure, I can do that shortly. I forgot about Set Analysis, that seems like a good way to do it and like it should work, but no results

Re: Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 15:38:48 GMT

I have attached a version of the report on my original post for reference.

Re: Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 15:45:22 GMT

I could add the field as a dimension to run my current Expression off of, but I'd like to be able to set these in the expression if need be as well.

Re: Expression Problem

Fri, 12 Sep 2014 15:49:25 GMT

okay i made it work..

Sum({<[Work Type] ={'PPA'}>}Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)

Count({<[Work Type] ={'PPA'}>}Phone#Identifier)*100

thats how.. but first you gotta delete all calculations in your chart.. I dont know why.. start creating a new chart that worked for me. let me know if you could get it to work pls

Re: Expression Problem

GabrielAraya — Fri, 12 Sep 2014 15:59:21 GMT

Hi ... The original expression definition is: Sum() / ( Count() * 100 ) ... in the case of Work Type = 'PPA', you should use:

Sum({<[Work Type] ={"PPA"}>}Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)

(Count({<[Work Type] ={"PPA"}>}Phone#Identifier)*100)

the original definition is

Sum({<[Work Type] ={"PPA"}>}Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)

Count({<[Work Type] ={"PPA"}>}Phone#Identifier)*100, for any reason the () in the COUNT produce a mistake

Re: Expression Problem

Fri, 12 Sep 2014 16:08:12 GMT

With " its not working you need ' so you can get it to work

Re: Expression Problem

MalcolmCICWF — Fri, 12 Sep 2014 18:18:30 GMT

Strange, I created a new chart and started plugging them in, sure enough it works. Well thanks for helping me figure this one out Patrick. Much appreciated!