Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculated dimension help - simple

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?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Calculated dimension help - simple

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.

4 Replies
MVP
MVP

Re: Calculated dimension help - simple

If(Question = 'A1a', Question)

Not applicable

Re: Calculated dimension help - simple

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

Not applicable

Re: Calculated dimension help - simple

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

MVP
MVP

Re: Calculated dimension help - simple

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.

Community Browser