Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

4 Replies
swuehl
MVP
MVP

If(Question = 'A1a', Question)

Not applicable
Author

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

Not applicable
Author

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

swuehl
MVP
MVP

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.

View solution in original post