Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ctslumesse
New Contributor

Pivot table with more dimensions

Hi,

the thing I'm working on is that pivot table should have data split by month. So I need to count different values from different sources and have them in one table, filtered by month, but every data source has own "date" field.
Please find attached screenshot where my pivot table doesn't work properly, and below 2 simple tables with proper data in it. I think that "Columns" section needs to be rebuilt but I don't know how.

The thing is that I need data from these 2 simple tables in 1 pivot table. Is it possible, if yes - how?

qlik2.PNG

Community Browser