Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Logic HelpI

Hi Evryone,

Need one help in logic,

I need to calculate Rate, logic is

first it shud calculate monthly avg rate, than if monthly avg rate not found than it shud get yearly rate, if yearly rate not found than get the rate from field1

how i can write the condition?

pls suggest.

4 Replies
senpradip007
Specialist III
Specialist III

Please share sample app to help you better.

its_anandrjs

Share some sample data please to have a look.

Regards

Anand

abhaysingh
Specialist II
Specialist II
Author

sry not able to share the data

t_chetirbok
Creator III
Creator III

Hi!

Find the example in attachment.

Hope it is what you need