topic Re: Only Problem in QlikView

Only Problem

nikhilgarg — Thu, 03 Sep 2015 08:39:27 GMT

Hey,

I am attaching an application where i ahve tried to see the working of ONLY().

But, in straight table:

1: Why i am not getting "Robert" as SalesPerson Name

2: Under Only Sales: according to me output should be:

Salesman Only Sales

Henric 10

John 10

Oleg 10

Tom 10

Please tell where i am wrong?

Anonymous — Thu, 03 Sep 2015 08:42:50 GMT

Robert has no revenue

When you goto tab presentation and unclick "suppress Zero values"

you will see Robert

qlikmsg4u — Thu, 03 Sep 2015 08:43:50 GMT

Only works if there is only one single value, if there are more than 1 value it returns null

alexandros17 — Thu, 03 Sep 2015 08:47:49 GMT

Take a look ...

nikhilgarg — Thu, 03 Sep 2015 08:48:05 GMT

Hey,

Thanks but for Only(Sales) they should return value except for Robert becoz for every salesperson other than Robert, Sales has unique value only.

nikhilgarg — Thu, 03 Sep 2015 09:37:25 GMT

Hey,

Thanks but for Only(Sales) they should return value except for Robert becoz for every salesperson other than Robert, Sales has unique value only.

nikhilgarg — Thu, 03 Sep 2015 09:37:35 GMT

Hey,

Thanks but for Only(Sales) they should return value except for Robert becoz for every salesperson other than Robert, Sales has unique value only.

alexandros17 — Thu, 03 Sep 2015 09:46:35 GMT

Yes and it works in that way, your expression is only(Total sales) that is you are not considering salesman as dimension ...

nikhilgarg — Thu, 03 Sep 2015 10:19:51 GMT

oopss my bad.

Thanks for pointing that i have used Total