Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

subtraction based on two field comparisions

Hi All

can some one help me out with the below senario.

_

Here i need to calculate for a particular D_idIf dhr  =  Ahr  then i need to calculate the count of A_id s

For D_id 101  in d_hour 12  i have two A_id s   11 and 17

So my count here is  2

So what is need isacpt-(donate/2)Which gives 211 -13/2 =205

so when i selectvalues in list box  Ahr for example say 12 it should be as below
which is my final output

0 Replies