Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Could someone help me to get the answers for the below questions? I also want to learn the reasons for the answer..
1) Which is the highest performing expression to accurately count the number of Account Owners?
2) 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?
3) The straight table does NOT show all rows from the Field1 list box What does this indicate about the dataset?
4) Two of the tables in the QlikView data model are Invoice Header (one million rows) and Invoice Detail (nine million rows) InvoicelD links the two Invoice tables.
This expression is used several times in the QlikView application, count (distinct invoiceiT) How can a business analyst optimize this expression for use in the application?
5) A data model contains 1 billion records and a straight table renders all of the data at the most granular level. The business users do NOT need all of the detailed information. The business analyst needs to improve the rendering time of the straight table.
Which two approaches should the analyst use? (Select two )
Anusha, I would recommend looking around in the Design Blog area, I am going to give you a couple/few direct links to some things I think may be directly related, and then the last link will be to the top level of the Design Blog area, you can use that one to search yourself for further posts that may help. There are 700+ posts in this area now from our experts and most are how-to related.
https://community.qlik.com/t5/Qlik-Design-Blog/Count-or-Count-distinct/ba-p/1469730
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regarding the straight table, you likely need to use Sum of Rows option there instead of Expression, as the latter will collapse duplicate rows. The other option is to use RowNo() or RecNo() in your load to ensure every row is unique...
I think this should get you started and on the right track, hopefully it helps.
Regards,
Brett