Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zahidrahim_ocp
Contributor

Date Passing to other table

Dear Experts,

I have made a qvd file with fields like:

Actual Sale

---------------------------------

TRX_DATE

SALE_VALUE

Now i want to make another qvd file with conditions on what is user selecting from above TRX_DATE

DUE_INVOICES

----------------------------------

DUE_AMOUNT

WHERE DUE_DATE < TRX_DATE (First Value from the selected dates)

AND DUE_DATE2 > TRX_DATE (Last Value from the selected dates)

What can/should be the approach?

Best Regards,

Zahid Rahim

2 Replies
JustinDallas
Valued Contributor

Re: Date Passing to other table

If it's dependent on what the user selects, then you might not really be able to make a QVD in the way you want.

zahidrahim_ocp
Contributor

Re: Date Passing to other table

Dear Justin,

Thank you for the reply. If i dont make a QVD then what are the other options i have.

Regards,

Zahid Rahim