Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maahivee
Contributor III
Contributor III

Displaying Month From Different Dates in one Report

HI Guys - I have a very strange requirement and I am having a bit of trouble figuring this one.

I need to display month of different dates from different tables in one single report as a dimension. it is not possible to combine these dates in the back end as they are from different tables in different modules and doesn't have any relation between them.

The months needs to extracted and displayed from each of these dates for each of these rows.

   

       JanFebMarAprMayJunQ2JulAugSepQ3OctNovDecDecQ4Total Year
2018 Sales Orders by Date11212121212121212121212121212121212
2018 Purchase Orders by Date213451345134513451345134513451345134513451345134513451345134513451345
2018 Forecast by Date314561456145614561456145614561456145614561456145614561456145614561456

I guess this table should give you an idea of what i am trying to do, first row values should be displayed by using month from Date1,

second row values should be displayed by using month from Date 2 and so on, the difficult task here is combining and displaying all these into a single report so when the user downloads it, it goes in one excel. these all are different dates from different tables in different modules, so there is no way of joining these, but just for this one report for comparison purposes i need to display like this.

How to create monthly buckets with different dates in one single report is what my question is.

1 Reply
bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

Please find attached the Solution Qvw, i have used the Date bridge in-order to combine the different dates and also used inline table to create the dimension fields values as Forecast value, purchase order, sales order.

Solutions.PNG

If you find this helpful please mark as helpful or correct.

Regards,

Bhasker Kumar