Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tugay_ozturk07
Contributor
Contributor

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

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.

Labels (1)
0 Replies