Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative in Pie Chart

Hi,

It is possible to put in a Pie Chart Positive and Negative values in the same chart?????

I need Help with this plz

Regards

Carlos

26 Replies
Not applicable
Author

Can you explain me a little more about the formula? i have a question, as I mentioned i manage the info with the Month Field and Year Field, what are you putting in (Date) inside the formula, actual date? and do you put that formula in the listbox's expression or in the load of a table??

Regards

And sorry for all my questions Im newbie in qlikview

Not applicable
Author

Hi,

The Date is the Specific date Ie 17/02/2010, it is best if you add in the script so that it is not calculated every time.

Hope this is of help,

Regards,

Neil

johnw
Champion III
Champion III

You'd use the formula during the load of your calendar in the script, or wherever you're loading your Month and Year fields. I'm assuming that your calendar has a field Date. In any case, you'd use the same Date field that you're using to establish the Month and Year, assuming you're doing it that way. So you might have something like this:

[Calendar]:
LOAD
Date
,year(Date) as Year
,month(Date) as Month
,date(monthstart(Date),'MMM YYYY') as "Month Year"
;
LOAD DISTINCT Date
RESIDENT [My Data]
;

There are more efficient ways to get the list of distinct dates, but they're also more complicated, so I figure this makes for a better example. I'll also usually generate my calendar for every day in the range, not just for dates for which I have data, but that's more complicated still, so again, trying to keep the example simple.

Not applicable
Author

Hi Jhon, i found a way to do this think but it is su much complicate, because what i did was duplicated my rows but with diferent name and it works good, but raise my reload time, can you help me with other way, i can not use the one at the top of this post because actually i dont manage a entire date, i only have months and years and not a entire date, can you help me with this plz?

Regards

Carlos

johnw
Champion III
Champion III

I'm not sure quite what you're asking. But if you need to make a date from just a month and year, one way is the makedate() function:

date(makedate(Year,Month,1),'MMM YYYY') as "Month Year"

Not applicable
Author

Thank you for the answer, it works very good, but now what i need to do is put another "Month Year" that works independent of the first one, it is possible??

johnw
Champion III
Champion III

What do you mean by independent? If you want it COMPLETELY separate from any of your main data, you can create a calendar of month years with a different name. For instance:

[Separate Calendar]:
LOAD fieldvalue('Month Year',iterno()) as "Separate Month Year"
AUTOGENERATE 1
WHILE len(fieldvalue('Month Year',iterno()))
;

Not applicable
Author

Hi John:

Now the problem is diferent, the question is:

How can i do to sum(Sales) on November and December 2009 and January and February 2010 without a YEAR MONTH filter??

Regards

Carlos

Not applicable
Author

I have issues with negatives in pie charts adn would simply like the pie chart to just ignore the negative values, is this possible?

mike_garcia
Luminary Alumni
Luminary Alumni

As an option for displaying negative values in Pie Charts, I would suggest the Google Charts API, in which (for the Pie Chart) negative values are returned as blank slices. Might be useful for some situatuions.

Here is the link http://code.google.com/apis/chart/docs/gallery/pie_charts.html

Regards,

Mike.

Miguel García
Qlik Expert, Author and Trainer