topic Re: How to filter the data. in QlikView

How to filter the data.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have managed to filter the data in this scenario where my requirement is to pull only the "Live service attributes" and their "totals" for the respective months.

I have used the expression only to pull the "Live services" onto the group name without 'Test service' which is not required.

I have managed to some extent on the group name showing only the Live services but How to stop the Test service attributes in the rest of the attributes and their totals.

Here is the file I am working on.

First Pic shows all the data in the Group name Including Test service which is red rounded circle having the service id's.Only the green is the one we are interested.
Second Pic shows in the group name only showing the Live services that starts with number 272 attribute. but you can see those total value for the service attributes is not changing even after filtering the data.

Dont know where i am doing wrong or Am i missing something.

Let me share the expression I have used.

"=if(not WildMatch(service_name, '*Test*'),group_name)" n Group_name dimension.

Any help is really appreicated.

thanks.

Re: How to filter the data.

xyz1 — Sun, 14 Apr 2019 11:28:27 GMT

Re: How to filter the data.

xyz1 — Mon, 30 Jan 2017 11:32:58 GMT

let me know if it works.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 11:42:42 GMT

No It is not working .It is pulling all the data including TestService.

Re: How to filter the data.

xyz1 — Sun, 14 Apr 2019 11:29:14 GMT

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 11:54:36 GMT

I have already used that expression which is working pulling the Live services but my issue is that expression is not stopping the test service attributes coming on to the pivot table.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 11:56:35 GMT

Hi Vamsi,

There is nothing wrong with your expression. Check "Suppress Null Value" for your dimension in chart properties will solve your problem.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 12:00:08 GMT

Hello Vamsi,

Try this. Suppress Null values for your calculated dimension.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 12:00:25 GMT

Brilliant.Thanks vishwa.I was breaking my head on this since morning.

That thing changed the figures though not sure if it is wat my PM wanted.

But thanks for your help.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 12:02:24 GMT

Hi Vamsi,

Please mark it as helpful if it solved your issue. Thanks.

Re: How to filter the data.

Anonymous — Mon, 30 Jan 2017 12:04:41 GMT

I will do that viswa in next 10 mts.

Thanks.