Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Showing data of months of different years in same table

Hello,

I want to know a way to show data of months of different years in a same table.

I need to make a count function, in a way that in a row will be displayed data of the past year, and in another row, data of the current year.

The data format is set for DD-MM-YYYY.

Thanks for any help.

3 Replies
Not applicable

Showing data of months of different years in same table

Hi,

Try in the load to add a filed 'Year' . For example:

Load *, Year(yourDate) as RecordYear.

Then you can add RecordYear as a dimension.

You can also add a calculated dimension in the chart directly:

Year(yourDate) as DimensionYear

Regards

vijay_iitkgp
Valued Contributor

Showing data of months of different years in same table

Hi,

You can do it in Straght table, Take Year and Month as Dimension and use Count() in you expression and in presentation Hide Year.

Hope this will help

chauhans85
Esteemed Contributor

Re: Showing data of months of different years in same table

see the attached file

hope this helps

Community Browser