topic Calculated dimension help - simple in QlikView

Calculated dimension help - simple

Wed, 14 Aug 2013 10:40:21 GMT

hi,

I can't remember the syntax (the god awful syntax...)

Can someone help me ?

I want to make a calc. dimension which does the following

Question = 'A1a'

If i were writing in SQL, what I'm after would look like this:

SELECT

Question

WHERE

Question = 'A1a'

Could anyone help me get my syntax correcT?

swuehl — Wed, 14 Aug 2013 10:45:14 GMT

If(Question = 'A1a', Question)

Wed, 14 Aug 2013 10:47:28 GMT

Thanks- and how do i exclude all results not equal to A1a?

Wed, 14 Aug 2013 10:50:25 GMT

If(Question = 'A1a', Question) - This only returns A1a values and excludes all others

swuehl — Wed, 14 Aug 2013 10:51:11 GMT

Not sure if I understand, above calculated expression should only show the value A1a.

Ah, you may need to enable the option 'Suppress when value is NULL' on dimension tab.