Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Showing year separetely/ only finished time in a line chart

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

7 Replies
MVP
MVP

Showing year separetely/ only finished time in a line chart

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

Not applicable

Showing year separetely/ only finished time in a line chart

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

Greetings,

Beata

Not applicable

Showing year separetely/ only finished time in a line chart

I forgot:

Any idea how to show 2008 and 2008 separetely?

Thank you,

Beata

MVP
MVP

Showing year separetely/ only finished time in a line chart

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)


Not applicable

Showing year separetely/ only finished time in a line chart

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

I am very thankful, have a great day!

Beata

Not applicable

Showing year separetely/ only finished time in a line chart

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

MVP
MVP

Showing year separetely/ only finished time in a line chart

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.