topic Re: Dynamic Pivot table in App Development

Dynamic Pivot table

Kaushik2020 — Tue, 11 Jul 2023 08:28:53 GMT

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.

Re: Dynamic Pivot table

tealowk — Tue, 11 Jul 2023 09:29:07 GMT

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

Re: Dynamic Pivot table

Kaushik2020 — Wed, 12 Jul 2023 05:35:15 GMT

thanks a lot for clarifying. it is working fine.