Set analysis by Client

[#1]

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!

[simenkg · Accepted solution]

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

Cheers
SKG

[jagan]

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.

[simenkg]

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

[jagan]

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.

[#6]

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

[#7]

Thank you kindly for your response as well, jagan