Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, this is probably an easy one, but I am a complete beginner and so far I have not found a solution online.
I have a data set and generated a table of KPIS, such as sums of different revenues and more... My dimension in this table is Business Units and the table has one row with the KPIs for each Business Unit. The table automatically inserted a row at the top that has the total values of each KPI.
For some diagrams and further calculations, I want to use the numbers from the top row, the "total" values. What is the dimension to get these values or how can I use the table that already has the values?
Hope I could explain my issue and I am really thankful for your help!
If new number is inserted, Is there any Data which associate with? If so, Try this way
FirstSortedValue(Value, -DateField)
If Anil's post did not help, I believe you will likely need to use Set Analysis to get what you want for this use case. Here is a specific Design Blog post that will get you started, but I am also including the base URL for the entire Design Blog area below that, so you can further search yourself if you wish. The Design Blog area is comprised of hundreds of mostly how-to items developed by our internal experts on the products, so it should be a helpful link to keep handy.
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/bg-p/qlik-design-blog
Lastly, if someone's post does help you, be sure you use the Accept as Solution button on that post to give the poster credit for the assistance and to let other Community Members know that solved your use case question. If you need further assistance, please leave an update post for everyone on what you are still stuck trying to figure out.
Regards,
Brett