Discuss Qlik QV12BA Exam Topic 3 Question 9

A business analyst needs to sort the values for the Product dimension explicitly as "Planes", then "Trains", then "Automobiles" The analyst needs a highly optimized solution to provide the best performance for an application with between 900 million and 1 billion records

Which solution should the analyst use?

AUse the Ord function in the user interface to sort in a custom order

BBuild nested IF statements in the user interface to assign numeric values, then sort numerically

CCreate a new calculated dimension in the Ul named ProductSort, then sort the Product field by the new ProductSort field

DAssign a numeric value to the Product values using the DUAL function during the data load, then sort numerically in the Ul

Suggested Answer: C

Get Premium QV12BA Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

11 comments · newest first

Janella 12 months ago

B could work, but it might get messy with so many records.

Holley 12 months ago

A custom order with the Ord function sounds simple enough.

Franchesca 12 months ago

Wait, can you really use the DUAL function for sorting?

Rosendo 1 year ago

Not sure about that, D seems more efficient for large datasets.

Aileen 1 year ago

I think option C is the best way to go!

Huey 1 year ago

I vaguely recall something about using the DUAL function during data load; that might be the most efficient way to handle this.

Hector 1 year ago

I feel like creating a calculated dimension could be a good approach, especially since it allows for more flexibility in sorting.

Sharan 1 year ago

I remember practicing sorting dimensions, but I'm not sure if the Ord function is the best choice for such a large dataset.

Chuck 1 year ago

I think using nested IF statements could work, but it might not be the most optimized solution for performance.

Bernadine 1 year ago

Wait, I'm a bit confused. I thought the order was different. Let me re-read the question and options carefully before answering.

Jacki 1 year ago

I think the responsibility shifts from the service developer to someone like a service custodian, but I'm not totally sure about that.

Qlik QV12BA Exam - Topic 3 Question 9 Discussion