Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
VamsiBhagavathula1

Common Calendar dates problem

Hello ,

I have a peculiar problem with common calendar script. I need to show  orders placed in the month similarly display refund requests processed in a month using a common calendar. I am using Standard Qlik Calender Torben Seebach/Martin Didrikse calendar. The problem is with the REFUNDS calendar. It creates multiple rows for a single date like you see in screenshot attached though i have only one row matches the scenario.

Has anyone faced similar issue? If yes can you please  let me know the how to tackle this problem in qliksense

QVF file is attached as well.

 

ORDERS
C_ID ORDER_DATE AMT
ABC 23.01.23 50

 

REFUNDS
C_ID REFUND_DATE REASON REF_AMT
ABC 01.02.23 PART1 10
ABC 27.03.23 PART2 20
ABC 04.04.23 PART3 10

 

VamsiBhagavathula1_0-1682236108589.png

 

Best Regards

Vamsi

 

 

 

 

 

Labels (4)
0 Replies