Dynamic Pivot table

[Kaushik2020]

Hello everyone, 

I have a date field in my database. based on the the date, Month-Year is derived and represented as columns in Pivot table.

is there any way the data for the month of August will auto show once details are added in the database ? 

Attached is the sample view.

Expectation is the count (Value ) for these KPI's should show based on the month-year in the pivot table.

[tealowk · Accepted solution]

Hi Kaushi,

The default behaviour of Qlik Sense is that the month of August will show automatically once there is data present in the data base.

You can check vice-versa by limiting the data load to dates prior or equal to 31/05/2023 and you'll see how the columns for Jun-23 and Jul-23 will disappear.

Hope that helps.

Kind regards from Brussels,

Thilo

[Kaushik2020]

thanks a lot for clarifying. it is working fine.