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 11 months ago

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

Holley 11 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 12 months 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