Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
markgraham123
Valued Contributor

Set analysis statement for If statement

Hi All,

Regarding performance, Set analysis or If statement???

Which would work quicker.

Could someone help me in scripting the below statement using Set analysis

=count(DISTINCT(If(Name='John',Awards)))

1 Solution

Accepted Solutions
Highlighted
marcus_malinow
Valued Contributor III

Re: Set analysis statement for If statement

Set analysis is definitely quicker!

count({$<Name={'John'}>} DISTINCT Awards)

View solution in original post

2 Replies
Highlighted
marcus_malinow
Valued Contributor III

Re: Set analysis statement for If statement

Set analysis is definitely quicker!

count({$<Name={'John'}>} DISTINCT Awards)

View solution in original post

Highlighted
markgraham123
Valued Contributor

Re: Set analysis statement for If statement

Thanq Marcus