Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sorry for the basic questions - I am really new to Qlikview...
I have a dataset which includes fields similar to the ones below. I want to create a table that shows the the sum of the calculated column, but only where Text = 'A'
Could anyone suggest a good way of doing this?
Text | Calculation |
---|---|
A | =if(Sum(X)=0,null, Sum(X)/Sum(y) |
A | =if(Sum(X)=0,null, Sum(X)/Sum(y) |
B | =if(Sum(X)=0,null, Sum(X)/Sum(y) |
try this:
sum({<Text={'A'}>}X)