Exists function for charts?

danielact — Fri, 25 May 2012 13:42:44 GMT

Is there a comparable function that can be used in charts?

I have a data set which I want to filter using a dummy field for various reasons. I have 9 fields, but let's use one to start. Let's call it User. So I created another table with the field called User2 from the original set.

Here's my dimension and expression:

Dimension: =pick(match(num(aggr(rank(sum({1}Loss),4,1),Year_Sequence)),

1000,500,200,100,40,20,10,1),'1/10','1/20','1/50','1/100','1/250','1/500','1/1000','1/10000',)

Expression: sum({1}Loss)

So I want to be able to filter the data using the User2 field, not the original User field. I think an exists function would be good for this, but that's only for scripts, not objects, right?

Any ideas on how to do this? Please don't try and convince me to do it with the original field, I have reasons for not wanting to - it's just complicated to explain why.

Re: Exists function for charts?

jonathandienst — Fri, 25 May 2012 14:38:18 GMT

I think that you could use the P() function, like this:

Sum({1<User1 = P(User2)>} Loss)

Regards

Jonathan

Re: Exists function for charts?

danielact — Fri, 25 May 2012 15:05:44 GMT

Worked perfectly! Thanks!

topic Exists function for charts? in QlikView

Exists function for charts?

Re: Exists function for charts?

Re: Exists function for charts?