topic Chart Presentation in QlikView

Chart Presentation

tresB — Fri, 24 Dec 2010 09:52:20 GMT

Hi All,

I have 100 values(1,2,3,...100) in bar chart to show. I want 10 out of them display like 91,92,93,...100. i want to do it at presentation level only. limitimg the presentation to max=10 would not solve my problem, because then i would get 100,99,...91 or 1,2,3,...10 depending on the sort order. i can't limit the calculation or use calculated dimension to limit it. so only way is at presentation level.

Any idea?

Thanks & regards,

tresesco

Chart Presentation

Fri, 24 Dec 2010 10:23:15 GMT

Hi,

view attached file.

I use two variables and set analysis.

Alex

Chart Presentation

Fri, 24 Dec 2010 10:38:04 GMT

Tresesco,

Alex's 3'rd and 4'th charts may be your solution.

But, why can't you use calculated dimension. You can give if ( dim > 90 and dim < 101 , dim ) and check on the " suppress when value is null " for this calculated dimension.

Reg,

Shubhu

Chart Presentation

tresB — Fri, 24 Dec 2010 11:04:11 GMT

Thank you Alex, for your attempt.

But as i mentioned in my prev post, i cant limit it neither from calculation (expression) or from calculated dimension option, because my calculation is based on inter-row (Above()/Below() function). so if the calculation is limited, then my result will vary. so i need it merely at presentation level.

Hi Subhu, this is why i can't use calculation limit or...

regards, tresesco

Chart Presentation

Mon, 16 May 2011 12:24:01 GMT

Old question, but I bumped in to it by accident I guess.

You can use if statetments to calculate chart values.

Example:

if(calculation is < 80, do calulation, 0)

then suppress 0 values not to be shown in the graph.Maybe that would solve your issuse?

Also, remember 0 values is not the same as zero values

Carl