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.
