Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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
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"
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??
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()))
;
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
I have issues with negatives in pie charts adn would simply like the pie chart to just ignore the negative values, is this possible?
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.