Qlikview Chart With no Expression

[aliyoung92]

My Data is already in the format I want it, using Excel and SQl scripting.

How do I create a chart expression, that simply reads the existing data without any additional sums etc.

I also want to add some modifiers to this expression,

i.e. =(Data) Where School = School A

Thanks in advance

[Anonymous]

sum({< School = {'School A'} >} YourValue)

[aliyoung92]

Thanks, however I don’t want to Sum

The data I have loaded in has already been summed, I simply want to display it, but with an additional filter built into the expression.

[Anonymous]

if( School = 'School A', YourValue)

[alexpanjhc]

What chart you using?

Let's say you use a straight table, you can just create a expression in the definition, just put a random number say 1 and then in presentation, you can hide that column,

Hope it helps.

[eduardo_sommer]

If you don't want to use the sum function you can use the only function or, use the field in an IF function (it uses an implicit Only function)

=only($<School={'School A'}>} Value)

If, for any reason you have more than one value for School A, the function returns a null value.

Eduardo