topic Re: Set analysis by Client in QlikView

Set analysis by Client

Thu, 11 Dec 2014 01:04:22 GMT

Hi All,

I have a requirement for an app that is to show in a table a statistic, and then show the statistic for a specific client, regardless of whether the client has been selected from the client filter. To do this, I figured I would use set analysis per this discussion.

I am pretty new to this concept, but I am having trouble getting it to work for my app. Please take a look at my sample qvd to see if you can tell where I'm going wrong. I'm sure it's an easy fix.

Thanks!

Re: Set analysis by Client

simenkg — Thu, 11 Dec 2014 01:38:09 GMT

The syntax is :
Avg({<Client={A}>} Number)

Cheers
SKG

Re: Set analysis by Client

jagan — Thu, 11 Dec 2014 02:21:28 GMT

Hi,

You missed the braces for A, also you need to give single quotes for client, check the expression below

=Avg({<Client={'A'}>} Number)

Hope this helps you.

Regards,

Jagan.

Re: Set analysis by Client

simenkg — Thu, 11 Dec 2014 02:50:15 GMT

You do not need quotes for string values if they do not contain spaces.

Re: Set analysis by Client

jagan — Thu, 11 Dec 2014 03:30:13 GMT

Hi Simen,

You are correct, there is no need of quotes for values that do not contain spaces, but I think this just sample data in real data there may be spaces. Just for safe side I suggested putting Quotes for values.

Regards,

Jagan.

Re: Set analysis by Client

Thu, 11 Dec 2014 17:36:58 GMT

Ahh I knew it was something so simple. The pages I was looking at all said the syntax was <a=> so I didn't get the whole story

Re: Set analysis by Client

Thu, 11 Dec 2014 17:37:13 GMT

Thank you kindly for your response as well, jagan