Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Full timeline of one year in bar chart

Hi,

i am trying to create a full timeline for one year (Jan-Dec) in a bar chart having only 2 month with values for the current year.

The chart should be displayed in a report always displaying a full year. I tried to create a calender with the format YYYYMM filling up the missing values. I presume that the missing month are not displayed because the data table is having only 2 month filled with values.

I already checked other posts but didn't find the right solution.

I attached the example.

Regards

Markus

12 Replies
Not applicable

Full timeline of one year in bar chart

HI can you share you application

Not applicable

Full timeline of one year in bar chart

Hi,

a example is attached above. I can't share the original.

Not applicable

Full timeline of one year in bar chart

HI,

In your application , yo have used expression as

SUM ({$< YEAR = {"2011"} >} commissions)

Its hard coded to Year 2011. So it will show data only according to year - 2011.



Chage It to

if( Year = $(=Max(Year)) , Commissions)

I hope this will work.

Not applicable

Full timeline of one year in bar chart

On Chart Properties > Presentation ... uncheck ... Suppress Zero-Values

Not applicable

Full timeline of one year in bar chart

Hi,

sorry but that didn't work.

Not applicable

Full timeline of one year in bar chart

Hi,

i tried that already but then the x-axis has all vlaues declared in the calender but displays only bars in 2011.

My intention is to have a chart displaying a full year on the x-axis (Jan-Dec 2011) having only bars for January and February (values are only available for these 2 month)

Not applicable

Full timeline of one year in bar chart

In your apllication data is only availabe for 2 months which is displaying on front end.

when it will have data for all the months , it will display Jan-Dec.

Here in aplication you can select on differnet years to do analysis

Not applicable

Full timeline of one year in bar chart

Ashwin,

thanks for the example. But it is not exactly what i am trying to do. What i mentioned before is to have the full year being displayed on the x-axis (Jan-Dec) in the bar chart. In the chart there should be only bars for January and February and March to December i presume would have Null values and the month < 2011 should be also suppressed.

tanelry
Contributor II

Full timeline of one year in bar chart

In the script add pure month dimension to your calendar table,
I mean using month(...) as month.

Then use this month as your chart dimension and check "suppress zero values".

Community Browser