Discussion board where members can get started with QlikView.
Can anyone tell me the best way to transform this SQL Statement into an action in a Button?
Basically, I want the button to select all values where the sum of GROSS1 OR GROSS2 are NOT Equal to Zero..
LINE# GROSS1 GROSS2
1 0 400
2 400 800
3 0 0
So, LINES 1 & 2 should be returned at the click of the button.
The negation of that would be helpful too. (Values where GROSS1 AND GROSS2 = 0)
Go to Solution.
Check out the attached application
maybe you can add a flag (thanks Sunny, I used your .qvw)
LOAD * Inline [
LINE#, GROSS1, GROSS2
1, 0, 400
2, 400, 800
3, 0, 0
Left Join (Table)
if(sum(GROSS1) + sum(GROSS2)>0,1,0) as Flag
group by LINE#;
and in the action of the buttons
No problem at all