topic alert for scatter chart in QlikView

alert for scatter chart

Wed, 13 Apr 2011 08:23:15 GMT

hai everyone, and a challenging question to all qlikview experts...

i having scatter chart in my file, in that all defects are placed in it. see below img

now my requirement is placing an "alert" for more defects (i.e; sum(numofdefects) is gretethan 5) then it should an alert message every time when cusor is moved on image spots.

alert for scatter chart

pover — Wed, 13 Apr 2011 14:58:45 GMT

I don't think it would be a good idea to force the user to put his mouse over each point to see if the defect is greater than 5. A scatterplot is used to see general patterns, so I would use a bar chart see all defects greater than 5 for specific categories in a easy way. Also in the scatterplot, I would color every dot a light color on a white background except for the dots with a defect greater than 5. I would make those dots stand out with an intense color.

Regards.

alert for scatter chart

Thu, 14 Apr 2011 05:24:51 GMT

hai karl,

when the cursor placed it should just display alert for where more than 5 defects in same place.

Is there any possible of working like this.

Thnks

alert for scatter chart

pover — Mon, 18 Apr 2011 23:27:07 GMT

Hi venkat,

You could add an expression that just appears in the pop-up message. The expression check if the x and y expression are the same and count the number of instances that are the same and if the number of instances is greater than 5, it would insert a 'Alert' text in the pop-up message. Would something like this work for you?

Regards.

alert for scatter chart

Tue, 19 Apr 2011 12:02:19 GMT

hi karl,

please can you give me a sample expression for how to create it. Take your own example based on only two fields the expression should work.

Thanks

alert for scatter chart

pover — Tue, 19 Apr 2011 18:43:20 GMT

Hi Venkat,

Here's an simple example.

Regards.