topic Re: Filter from an expression in a chart in QlikView

Filter from an expression in a chart

Thu, 14 May 2015 13:29:55 GMT

I have an expression called Passing in a straight table chart. The expression is:

Maxstring({<[Field1]={1},[Field2]={2},[Date1]={">=$(v_Period1) <=$(v_Period2)"},[Field3]={'YES'}>} [Field4})

Field4 always equals yes. Therefore, if the above set analysis conditions are met, Yes or Null are returned. Null Symbol under presentation is set as No.

This expression needs to be dynamic because v_Period1 and v_Period2 are variables calculated from Min and Max statements that need to change when filtering by department for example.

Our users want to be able to filter the Passing coulmn in the straight table chart to see either No or Yes. I have tried several different things (including an expression in a list box) but cannot make this work.

Does anyone have any suggestions?

Thanks in advance,

Drew Collins

Re: Filter from an expression in a chart

buzzy996 — Thu, 14 May 2015 13:40:12 GMT

may be, create variable and list all ur fields in list box of that variable.

and pass that variable as parameter to ur field.

Re: Filter from an expression in a chart

sunny_talwar — Thu, 14 May 2015 13:42:24 GMT

Not completely sure if I understand your requirement, would you be able to share a sample?

Best,

Sunny

Re: Filter from an expression in a chart

Anonymous — Thu, 14 May 2015 13:45:41 GMT

I noticed that you have a curly bracket in Field4, if that's the actual formula you are using change it to ]

[Field4})

Re: Filter from an expression in a chart

Anonymous — Thu, 14 May 2015 13:49:02 GMT

Did you try "Searchable" checkbox?

Re: Filter from an expression in a chart

stigchel — Thu, 14 May 2015 13:57:35 GMT

A listbox with expression

=If(Field4='Yes','Yes','No')

Or am I missing something?

Re: Filter from an expression in a chart

Thu, 14 May 2015 14:18:59 GMT

That was actually a typo while I was posting.

Re: Filter from an expression in a chart

Thu, 14 May 2015 14:19:53 GMT

Piet, Field4 always equals Yes.

Re: Filter from an expression in a chart

Thu, 14 May 2015 14:23:28 GMT

Sunny, I cannot share an example as this contains highly sensitive information.

Re: Filter from an expression in a chart

stigchel — Thu, 14 May 2015 14:24:55 GMT

Yes I know, have you tried?

Re: Filter from an expression in a chart

Thu, 14 May 2015 14:38:11 GMT

Yes I have. Since Field4 is always Yes, the result of the if statement is always Yes.

Re: Filter from an expression in a chart

Anonymous — Thu, 14 May 2015 14:47:49 GMT

What's the actual output you have right now, can you atatch an image? Since you can't share the document

Re: Filter from an expression in a chart

stigchel — Thu, 14 May 2015 15:23:36 GMT

Well it depends on your data(model). Assuming that you have an id your data somewhere use

=Aggr(If(Field4='Yes','Yes','No'),Id)

It will select Id's accordingly

Re: Filter from an expression in a chart

Thu, 14 May 2015 17:12:54 GMT

I put the set analysis statement in as in an if statement. Using the Aggr with ID, it appears to work! Thank you.