topic Re: How do I exclude data from being shown on my graph in QlikView

How do I exclude data from being shown on my graph

jcharles — Fri, 14 Feb 2014 11:41:25 GMT

I have used set analysis in a dimension to exclude data from my selection and it's working. The only problem is that my graph is showing the data I want (OPENSTATUS) as well as the data I don't want to see on the graph (CLOSEDSTATUS). Please see the attachment. How do I get my graph to not show the CLOSEDSTATUS?

My dimensions are:

=AGGR(ONLY({STATUSTYPE-={‘CLOSED’}>}STATUSTYPE),STATUSTYPE)

BRANCH

My expression is:

=AVG(TODAY() – REPORTEDDATE)

Please help - Thank you.

Re: How do I exclude data from being shown on my graph

kumarnatarajan — Fri, 14 Feb 2014 11:51:13 GMT

Hi,

Try below syntex

=if(WildMatch(STATUSTYPE,'CLOSED*'),null(),STATUSTYPE)

and check the suppress when value is null option

Re: How do I exclude data from being shown on my graph

MK_QSL — Fri, 14 Feb 2014 11:52:08 GMT

My dimensions are:

=AGGR(ONLY(<{STATUSTYPE-={‘CLOSED*’}>}STATUSTYPE),STATUSTYPE)

BRANCH

Re: How do I exclude data from being shown on my graph

sundarakumar — Fri, 14 Feb 2014 11:54:40 GMT

Try using

if(STATUS_TYPE='Closed',closed,null())

as dimension and check suppress null selecting the new calculated dimenion in the dimesion tab..

-Sundar