Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-07-09 04:44 AM

set analysis and calculated dimension

Hi,

I'm looking at creating a calculated dimension with set analysis where the values of two fields are compared.

eg. origin = destination or same_origin_and_destination_flag = 1

currently, I use an 'If" statement but am wondering if this can be done using set analysis instead.

(There are approximately 2 million rows in the table that needs to be analysed and would like to compare which is a better option)

Any help with the syntax is appreciated.

2,179 Views
0 Likes
1 Reply
johnw
Champion III
Champion III
‎2010-07-09 09:45 PM

It sounds like you're looking for the solution which lets the chart calculate the fastest? I wouldn't use a calculated dimension or set analysis then. Consider doing something like this in the script instead:

LOAD
ID
,origin
,destination
,if(origin=destination,ID) as ID_with_same_origin_and_destination
...

Then use the new ID field instead of the real ID field, and suppress nulls. I suspect that will be the fastest approach for the chart by a significant margin. Worth testing, in any case. Oh, and replace "ID" with whatever field you really wanted to play with if it isn't an ID. Same idea.

252 Views