showing record base on dates of other field

[swiftfahad]

hi grus,

I have invoice_id ,customer_id,invoice_date and invoice_amt in invoice table

I have voucher_id,customer_id,voucher_date and voucher_amt in voucher table

suppose i wana show record for the month of sep 2016 for a particular customer.

dimension is customer_id

sum(invoice_amt) in invoice graph

sum(voucher_amt) in collection graph

if i give selection on invoice date to see september 2016 record it correctly show sum of all invoice because selection is made on invoice date

problem is that i also wana show collection on that selection of septemer 2016 means selection on invoice data should work on both invoice and collection dates.

for example:

in oracle

select sum(voucher_amt) where

to_char(collection_date,'MON')= to_char(invoice_date,'MON')

hope you understand the problem

[neha_shirsath · Accepted solution]

For that you need to create one master calendar where both dates should be concatenated and create flag for identify.

If possible can you share some sample data.

[swiftfahad]

you mean to say some thing like this  mention in this article

Search Recipes | Qlikview Cookbook

[neha_shirsath]

yes exactly... You need to create common calendar for both.

[swiftfahad]

sure will try... thanks for reply

[neha_shirsath]

Welcome

If you find something helpful then close the thread.