Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nitin_01
Creator
Creator

Cell Value Comparision

Hi,

 

     There is a scenario where I need to calculate a rate effect for which logic is,

  (CurrentPrice-BasePrice)>=1 wherever I get this rate effect as 1 that should be seen in UI. Current Price comes from URL.

In shared excel my BasePrice comes from first date from field Date i.e. Min(Date), after comparing this BasePrice with next Prices, wherever we get the next first rate effect as 1, that date Price will be my BasePrice and this Price will be compared to next Price and so on.

In UI need to show flag's with 1 and there date. Its okay if we remove data with flag 0.

Price.png

 

Regards,

Nitin G.

4 Replies
sunny_talwar

So, based on your image above... which rows will display 1 and which ones will display 0?
nitin_01
Creator
Creator
Author

Hey Sunny nice to hear from you after long time.

Based on above image 1st ,3rd,4th,7th,10th,13th. Now this 13th Line item will be compared to Price coming from URL if again difference between Price is -1 or +1 then next base price would be the new compared price.
nitin_01
Creator
Creator
Author

1st ,3rd,4th,7th,10th,13th . These will be set as 1 and rest 0. As per logic.
nitin_01
Creator
Creator
Author

Please update.