Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-02-07 03:20 PM

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

req.qvw
495 Views
0 Likes
0 Replies