Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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
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
see the attached file
hope this helps