Data available for one Year but want to show monthly as bar chart

[#1]

Hi All,

We receive a file with just year (ex 2017) in the Date column, but requirement is we need to show bar chart for all the months (From jan to dec in 2017)

Please find attached.

Thanks

[sunny_talwar]

So is each file stamped with the Month it belongs to? If that is true you can extract the month from the file name.

Qlikview Extract Date from FileName() by RFB 148 - YouTube

[Anonymous]

Sounds like you need the same value repeated for each month.

Best way would be to create an inline table with months and do a join on them between the inline and your table.

If you only care about this 1 chart you could also add a calculated dimension with a valuelist.  And make it the 1st dimension.

=ValueList('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

[#4]

Hi,

No we just get the year filed , no month information is available.

But we need to show the count across all the months of that year and count should be same for all the months

Thanks