Showing year separetely/ only finished time in a line chart

[#1]

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

[Miguel_Angel_Baeyens]

To your A) question, Set Analysis would help you to do that with something like

Sum({< SalesYear -= {2010} >} Sales)

where SalesYear is a field containing only the year. Another option is

Sum({< SalesDateField = {"<=$(=Date('01/01/2010'))"} >} Sales)

where SalesDateField is your sales header field in which you have your dates.

Hope that helps

[#3]

It works great, thank you very much!!!!

Greetings,

Beata

[#4]

I forgot:

Any idea how to show 2008 and 2008 separetely?

Thank you,

Beata

[Miguel_Angel_Baeyens]

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

Sum({< Year = {2008} >} Sales)

and

Sum({< Year = {2009} >} Sales)

. Depending on how you want to display your data, give a try to

Sum({< Year = {2008, 2009} >} Sales)

[#6]

It works great and thanks to that I also made variance! Finally!

I am very thankful, have a great day!

Beata

[#7]

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

[Miguel_Angel_Baeyens]

As set,

{< CalendarYear = {2009}, CalendarQuarter = >}

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 =, CalendarMonth = {"Feb"} >}

or

{< CalendarYear = {2009}, CalendarQuarter =, CalendarMonth = >}

to likewise delete any selection for CalendarMonth.