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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in expression for the scenario

Hi,

I have to do lot of computation.

I have Main balance field,balance id in table A and Net balance field ,tx date,balance id in table B

Table A has balance id which table B is referring

every day balance i need to showcase.If the balnce for that a particular day is not available then in TABLE B we dont have any record. But i need to showcase previous days net balance if we have no data for that particular date.And i need to consider all dates

so i have created a date by defining stat date until current date

i have tagged this date to tx date of table B


Need help

How to achieve in expression.?

Regards,

Prajna

0 Replies