Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

Tags (2)
3 Replies
Highlighted

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

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

Specialist II
Specialist II

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

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')

Highlighted
Not applicable

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

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