Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Best Regards
Vamsi