Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
vinod_r
Contributor II
Contributor II

Null value handling

I have requirement of calculating Previous Year revenue with current year FX Please see attachments for Problem and Reuired Solution

- Final Amount should be converted into EUR with latest Year FX

- All selection combination must be possible after calculation

 

Looking forward for solution 🙂

 

Labels (2)
2 Solutions

Accepted Solutions
MayilVahanan

HI @vinod_r 

Its not in source itself. 

If you want to generate the missed data,  try like attachment, it will generate all missed info from txn table.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

vinod_r
Contributor II
Contributor II
Author

Got it..!!!

Thanks a lot @MayilVahanan 

View solution in original post

4 Replies
MayilVahanan

Hi @vinod_r 

One of the way to achieve the result.. Please verify

Thanks & Regards,
Mayil Vahanan R
vinod_r
Contributor II
Contributor II
Author

Thanks MayilVahanan,

But that doesn't full fill the condition of "Should be able to filter all values in the Mulitibox shown in the app " . Region Code 8235 is not selectable in your solution

 

Regards

vinod_r

MayilVahanan

HI @vinod_r 

Its not in source itself. 

If you want to generate the missed data,  try like attachment, it will generate all missed info from txn table.

Thanks & Regards,
Mayil Vahanan R
vinod_r
Contributor II
Contributor II
Author

Got it..!!!

Thanks a lot @MayilVahanan