topic Re: Qlikview Chart With no Expression in QlikView

Qlikview Chart With no Expression

aliyoung92 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview Chart With no Expression

Anonymous — Fri, 16 Dec 2016 16:17:25 GMT

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

Re: Qlikview Chart With no Expression

aliyoung92 — Fri, 16 Dec 2016 16:21:06 GMT

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.

Re: Qlikview Chart With no Expression

Anonymous — Fri, 16 Dec 2016 16:24:57 GMT

if( School = 'School A', YourValue)

Re: Qlikview Chart With no Expression

alexpanjhc — Fri, 16 Dec 2016 16:27:15 GMT

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.

Re: Qlikview Chart With no Expression

eduardo_sommer — Fri, 16 Dec 2016 16:37:05 GMT

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