topic Filter data for specific objects in QlikView

Filter data for specific objects

Anonymous — Sat, 02 May 2015 08:53:03 GMT

In the overview sheet you can see Phase Filter , if i select Phase II the data should have reflect in Emma Patient Enrollment plan Variance chart ,if i select any other phases the data should not to display , please anybody help me out

i attached below dashboard please go through it and give a replay...

Re: Filter data for specific objects

maxgro — Sat, 02 May 2015 09:48:24 GMT

you can try in Geneal tab of the chart with calculation condition (also replace the error message)

=concat(distinct STDY_PH) ='Phase II'

Re: Filter data for specific objects

Anonymous — Sat, 02 May 2015 10:09:58 GMT

It is showing calculation condition unfulfilled

Re: Filter data for specific objects

maxgro — Sat, 02 May 2015 10:37:25 GMT

when you select Phase II in the chart Emma......... the data is displayed

for other Phases the data isn't displayed

You can also move the expresson to layout -> show conditional (to hide the chart depending on Phase selection)

Isn't that your requirement?

Re: Filter data for specific objects

Anonymous — Sat, 02 May 2015 10:45:26 GMT

When i apply this condition on Layout it is showing only Phase II , But if i select any other phase it should have show 'no data to display'

Re: Filter data for specific objects

maxgro — Sat, 02 May 2015 10:52:50 GMT

try with the condition on general tab

and customize the error message

Re: Filter data for specific objects

Anonymous — Sat, 02 May 2015 10:56:33 GMT

Thank you it is working..

Re: Filter data for specific objects

Anonymous — Sat, 02 May 2015 18:27:05 GMT

i need one more requirement on this, if i clear all phases also Phase II should have show ,can you help me out??

Re: Filter data for specific objects

Anonymous — Sat, 02 May 2015 18:37:09 GMT

i need one more requirement on this, if i clear all phases also Phase II should have show ,can you please help me out??