topic Re: How to suppress the lines of the metrics using mapping in line chart. in QlikView

How to suppress the lines of the metrics using mapping in line chart.

qlikviewforum — Thu, 15 Sep 2016 11:12:56 GMT

In one of the line chart we have 3 metrics called as B,S and E. User wants suppress the lines of B and S for certain dates based on the dates that they mention in the excel.

So I am trying to make use of the below mapping to suppress the lines of B and S based on the user defined dates in excel. But still I could see that these lines are not getting suppressed in the line chart.

I cannot use "Suppress 0 Value" since it is will suppress values of those dates where B and S is actually 0 but user dont want to suppress those dates. So "Suppress 0 Value" wont work in this scenario.

MAP_EXCL_DATES:
Mapping Load distinct
Period,
null() as EXCL
resident EXCL_DATES
;

Any idea how come i overcome this scenario? Please help

Re: How to suppress the lines of the metrics using mapping in line chart.

miguelbraga — Thu, 15 Sep 2016 11:35:36 GMT

Hey there,

Can you please share with us a sample of your qvw or even a Excel table so we can provide you a solution?

One question, why mapping load with a field full of null values?

Also there is no 'Supress 0 Values' but this:

Regards,

Re: How to suppress the lines of the metrics using mapping in line chart.

miguelbraga — Thu, 15 Sep 2016 11:41:14 GMT

You can do what you want by doing this:

For B:

Sum({$<Date -= {'=($(vDatesUserB))'}>} B)

vDatesUserB = [Dates User B put in Excel];

For S:

Sum({$<Date -= {'=($(vDatesUserS))'}>} S)

vDatesUserS = [Dates User S put in Excel];

Regards,

Re: How to suppress the lines of the metrics using mapping in line chart.

Or — Thu, 15 Sep 2016 11:43:05 GMT

If what you are trying to achieve is a broken line chart - that is, specific dates being left blank and the line resuming on the next valid date - QlikView does not support this behavior in line charts (there's been enhancement requests for this as long as I can remember).

Re: How to suppress the lines of the metrics using mapping in line chart.

qlikviewforum — Thu, 15 Sep 2016 12:19:10 GMT

Can you please share with us a sample of your qvw or even a Excel table so we can provide you a solution?

--> Cannot attach the sample file due to security reasons.

One question, why mapping load with a field full of null values?

--> This mapping load don't have all the dates. So it wont suppress all the dates.

Also there is no 'Supress 0 Values' but this:

--> I cannot use this as I mentioned since it will suppress the records of B and S which user don't want to suppress. It has to suppress only for those dates which exists in mapping load.

Re: How to suppress the lines of the metrics using mapping in line chart.

qlikviewforum — Thu, 15 Sep 2016 12:27:58 GMT

Line should be left blank for "B" and "S" only for those specific dates but it should be available for "E".

Lets say user want to suppress "B" and "S" for 14-Jan-16 and earlier. Those dates will be there in the mapping load. I will use these mapping only for "B" and "S". So that chart should remain to say the values for "E" for 14-Jan-16 and earlier dates.

Let me know if you have any more questions.

Re: How to suppress the lines of the metrics using mapping in line chart.

Or — Thu, 15 Sep 2016 12:58:37 GMT

Your description is still not very clear, but as I understand it, my original post is correct - you are trying to achieve something QlikView does not support.

Re: How to suppress the lines of the metrics using mapping in line chart.

qlikviewforum — Thu, 15 Sep 2016 13:07:48 GMT

Ok I agree with you