Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

How to filter 1 column based another when creating a chart?

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?

TextCalculation
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)
1 Reply
Highlighted
sushil353
Honored Contributor II

Re: How to filter 1 column based another when creating a chart?

try this:

sum({<Text={'A'}>}X)