Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
6 years ago

Data according to dates

Hi all

 

I have this kind of data in qlik sense

 

kindly check this video

 

https://streamable.com/83v6j

 

here in this only 1 variable is save as a date .. what ever the date we write according to date data will be effect ..

 

here CR formula is

 

 

sum({<Flag = {'RC'},LOB = {'M'},PAID_DATE =  {'<=$(VpeDate)'}>}P_AMOUNT)

 

 

and ROS  forumla is

 

sum({<LOB = {'Mt'},RC_AS_OF_DATE = {'$(VpeDate)'}>}RS_AMOUNT)

 

 

I created in power bi but i drag all 2 dates separately like this

 

check this power bi video

 

https://streamable.com/ky0d5

 

i create these formulas in power bi

vcr = CALCULATE(sum(Paid_excel[P_AMOUNT]),Paid_excel[Flag]="RC",Premium_Excel[LOB]="MT)
vROS = CALCULATE(sum(RecoveryOS_excel[RS_AMOUNT]),Premium_Excel[LOB]="MT")

 

 

now i dont understand how i called date field in these formulas as same as i called in qlik sense ?

 

any help please

 

kinldy check videos .. by copying and pasting link in new tab so you will better understand

2 Replies