Qlik Sense dynamic date variable and dynamic grouping for selection on UI

tugay_ozturk07 — Wed, 01 Jun 2022 09:02:56 GMT

Hello everyone,

I'm trying to generate dynamic grouping for a column and counting the Member of transcation on Dashboard.

My data seems like below ;

ID	TYPE	TransDate
5da492a6fc3bb	ACCRUAL	12.04.2022
5da492a6fc3bb	ACCRUAL	12.04.2022
5da492a6fc3bb	CANCELLATION	29.06.2021
5da492a6fc3bb	MANUAL_ADJUSTMENT	15.04.2020
5da492a6fc3bb	MANUAL_ADJUSTMENT	15.04.2020



Description
Only Earn :type in ('ACCRUAL,'CANCELLATION')	If user select date between 15-04-2020 and 28-06-2021 my distinct count must be '1' for the JUST EARN
Only Burn :type in ('CANCELLATION')	If user select date between 29-06-2020 and 11-04-2022 my distinct count must be '1' for the JUST BURN
total Earn-burn :('ACCRUAL','CANCELLATION','MANUAL_ADJUSTMENT')	If user select date between 15-06-2020 and 12-04-2022 my distinct count must be '1' for the JUST TOTAL EARN+BURN

My vDate variable is LET vDate=today(); (YYYY-MM-DD)

How can I manage this scenario on QLIK SENSE UI.

Is there anyone here for the assistance. Is it possible to do that .

Thank you for your helps.

topic Qlik Sense dynamic date variable and dynamic grouping for selection on UI in App Development