topic Dates - Line Chart in QlikView

Dates - Line Chart

Mon, 24 Nov 2014 16:49:00 GMT

Hello -

Can you please help me figure out how to properly represent dates on my line chart?

Default settings:

Dimension:

Time_Period

Expression (default settings):

Rev Current Year (last 13 month) - =SUM({<month_offset={[>=-13<0]}>}sum_full_sell_price_usd_budget_current)/1000.
Rev Last Year (Last 26 month) =SUM({<month_offset={[>=-26<0]}>}sum_full_sell_price_usd_budget_current)/1000.

I also have built a "calendar" dimension table

YTD
Fiscal YTD
QTD
MTD
Last 13 Month

So now when user launches his report the default settings work as expected, the two lines represent last 13/last 26 month.

But as soon as they click on one of the calendar dimensions (i,e, YTD) the second line doesn't work. What function or formula should i be using? Please help

Thank you!

Re: Dates - Line Chart

Mon, 24 Nov 2014 17:10:45 GMT

Hello,

Just specify time fields that don't have to work for this chart, modify your expressions like this:

Dimension:

Time_Period

Expression (example):

Rev Current Year (last 13 month) =SUM({<month_offset={[>=-13<0]}, Year=,Month=, Day=,YTD=>}sum_full_sell_price_usd_budget_current)/1000.
Rev Last Year (Last 26 month) =SUM({<month_offset={[>=-26<0]}, Year=,Month=, Day=,YTD=>}sum_full_sell_price_usd_budget_current)/1000.

in above example I set time fields (I supouse you have Year, Month and Day Fields) = nothing (exclude them from selections) but If you have more just include them in set analysis.

I you can attach an example

Re: Dates - Line Chart

Mon, 24 Nov 2014 17:39:55 GMT

Hi Oswaldo,

I am almost there and your explanation makes sense! The formula densest work What else can i try?

Expression:

=SUM({<month_offset={[>=-13<0]},fiscal_quarter={[>=-13<0]},{<month_name={[>=-13<0]},{<month_start_date={[>=-13<0]},{<QTD={[>=-13<0}>} sum_full_sell_price_usd_budget_current)/1000.

Thank you!

Re: Dates - Line Chart

Mon, 24 Nov 2014 17:53:34 GMT

Hi,

"Field" + "=" + "," should works but you can try with out equal sign and use just dimension name like this:

Rev Current Year (last 13 month) =SUM({<month_offset={[>=-13<0]}, Year,Month, Day,YTD>}sum_full_sell_price_usd_budget_current)/1000.

I you can attach an example to test with the same qvw

Regards.

Re: Dates - Line Chart

Mon, 24 Nov 2014 19:04:36 GMT

The same result, densest like the commas.