Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I have some basic questions (ach beginnins with QlikView aren't easy!): a) how could I show sales for 2008 and 2009 as separate lines? I don't want to include 2010 cause they're too small to show yet (it's possible?).
b) Or from another site: If I use time as a drill group, can I show sales for untill today, but only for those time indicators that are finished ex. it won't show year 2010, month January, but it will show first week (when I will be drilling).
Thank you in advance,
Beata
To your A) question, Set Analysis would help you to do that with something like
where SalesYear is a field containing only the year. Another option isSum({< SalesYear -= {2010} >} Sales)
where SalesDateField is your sales header field in which you have your dates.Sum({< SalesDateField = {"<=$(=Date('01/01/2010'))"} >} Sales)
Hope that helps
It works great, thank you very much!!!!
Greetings,
Beata
I forgot:
Any idea how to show 2008 and 2008 separetely?
Thank you,
Beata
Hello,
Add "Year" as dimension in your chart, it will display any year you have in your data source. Bear in mind that you can add calculated dimensions, so if you don't have a "Year" field, your dimension may look like this
=Year(YourDateSalesField)
Another option is to create a new expression for each year, something like
andSum({< Year = {2008} >} Sales)
. Depending on how you want to display your data, give a try toSum({< Year = {2009} >} Sales)
Sum({< Year = {2008, 2009} >} Sales)
It works great and thanks to that I also made variance! Finally!
I am very thankful, have a great day!
Beata
Dear Miguel,
One more question:
I would like to make mini chart in my table, and I use following expression:
Sum({<CalendarYear= {2009}, CalendarQuarter=, CalendarMonth >}InvoiceAmount and it soesn't work.
I suppose it's some small mistake with bracets, do you have any idead?
Thank you in advance,
Greetings,
Beata
As set,
meaning you want to select calendar year = 2009 and deleting selection for CalendarQuarter. If you add just a field name (CalendarMonth), it won't work, you have to define a condition for that CalendarMonth field (equal to some expression), for example{< CalendarYear = {2009}, CalendarQuarter = >}
or{< CalendarYear = {2009}, CalendarQuarter =, CalendarMonth = {"Feb"} >}
to likewise delete any selection for CalendarMonth.{< CalendarYear = {2009}, CalendarQuarter =, CalendarMonth = >}