topic Re: Positive and negative values in Mekko in QlikView

Positive and negative values in Mekko

nehasaxena — Fri, 22 May 2015 00:44:28 GMT

Hi All,

I have requirement to create a mekko chart to show the differences. But there are negative values for some of the differences and Mekko chart is not working, it display message ' Positive and negative values'

Please suggest me is it possible to display negative values in mekko chart and how?

Thanks,

Regards,

Neha

Re: Positive and negative values in Mekko

danieloberbilli — Fri, 22 May 2015 01:01:59 GMT

Spontaneously I could not image how a mekko chart with pos and neg. values should look like.

Did you try to visualize it in Excel? I think its the wrong type of chart for that data

Re: Positive and negative values in Mekko

danieloberbilli — Fri, 22 May 2015 01:07:03 GMT

in the case the negative values should (visually) equal zero ...you might try something like if(sum(F1))<0, 0)