topic Re: Data Point -Show Value in QlikView

Data Point -Show Value

eigorman — Thu, 09 Jul 2015 02:26:29 GMT

Ok - so hoping someone can help me with this.

I am trying to figure out how to show one data point. I have a line chart. Dimensions are Reporting Month History & Testtype (HA, SR, CR, CA) . My expressions is Percent Proven Category. I set a dimension limit to show the overall compliance percentage using show total under options. I want to be able to show the data point just on the month I want to see it on. Reporting month usually, but be able to change it.

Obviously if I hit show Value on data points check box it will show all my data points. Does Show Value under the expression let you say to pick one data point to show. Can this be done on the dimension limit?

I can do this in excel and this makes it very frustrating to not be able to see how this is done in Qlikview.

Re: Data Point -Show Value

sunny_talwar — Thu, 09 Jul 2015 02:33:10 GMT

I suggest using background color for text color for the months you don't want to show.

HTH

Best,

Sunny

Re: Data Point -Show Value

sunny_talwar — Thu, 09 Jul 2015 02:38:29 GMT

Something like this?

Attaching the qvw for reference.

Best,

Sunny

Re: Data Point -Show Value

jagan — Thu, 09 Jul 2015 02:45:33 GMT

You can show value on data points conditionally by using

Chart Properties -> Expression-> Expand + icon of the expression -> Click on Show Value option and write the condition expression.

Hope this helps you.

Regards,

Jagan.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 02:53:33 GMT

Yeah I tried that. But not sure bout how my expression should be. I had it as

If(MonthName(Date(ReportingMonth='Jun 2015', Testtype).

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 02:54:33 GMT

And it only when I select that month - I will not want that. I want it to show what I want when I have a range selected.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 02:56:43 GMT

I didn't see qvw - but how are you making certain data points clear?

Re: Data Point -Show Value

jagan — Thu, 09 Jul 2015 03:00:49 GMT

Hi Edward,

Try like this, if your ReportingMonth having values like Jan 2015, Feb 2015, ...... and you used ReportingMonth as the dimension.

=ReportingMonth='Jun 2015',

If you attach sample file then it would be easier to analyse and provide the solution. Check below link for getting the solutions faster.

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 03:09:24 GMT

Yeah I will have to put together a smaller file with no other information.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 03:10:30 GMT

I did try that. It is still showing everything.

The ReportingMonth ='Jun 2015'

Re: Data Point -Show Value

jagan — Thu, 09 Jul 2015 03:11:50 GMT

If you attach sample then it would be easier to analyse and provide the solution.

Regards,

Jagan.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 03:21:11 GMT

OK. Take a look

Re: Data Point -Show Value

jagan — Thu, 09 Jul 2015 03:45:09 GMT

Hi,

There is no data for Jun 2015, when I changed to

=MonthName(Date(ReportingMonth_HASR_history))= 'Jan 2015'

and uncheck the Values on Data Points it is showing values for only Jan 2015.

Hope this helps you.

Regards,

Jagan.

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 12:37:03 GMT

Ok. Is there a way to only show the data on the dimension limit?

Re: Data Point -Show Value

eigorman — Thu, 09 Jul 2015 12:55:53 GMT

Got it. Thanks much. The one I sent you did not have the Jun data. But my other one does. Thanks for the help.