Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Cell Value Comparision

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

Re: Cell Value Comparision

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.
Highlighted
Creator
Creator

Re: Cell Value Comparision

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

Re: Cell Value Comparision

Please update.