Data Point -Show Value

[eigorman]

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.

Ed

[sunny_talwar]

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

HTH

Best,

Sunny

[sunny_talwar]

Something like this?

Attaching the qvw for reference.

Best,

Sunny

[jagan]

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.

[eigorman]

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

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

[eigorman]

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.

[eigorman]

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

Ed

[jagan]

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.

[eigorman]

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

[eigorman]

I did try that. It is still showing everything.

The ReportingMonth ='Jun 2015'