How to get Top 10 Values from multiple pivot tables in different sheets and create a new table with the result
Hi Coders,
I'm very new to Qlik Sense & I am working on a dashboard. I've couple of queries.
1. I would like to create a new field in Data Load Editor to calculate the difference of date.
Example: I have a field named "Date" in raw data and it loaded without any issues with load script.
I need a new field/variable lets say Days = Today() - Date (existing field), which should give the number or days between these dates.
2. I required to create multiple pivot tables (to show top 10 values only) in different sheets using different criteria for each pivot, with same data source, Now my requirement here is I need a summary sheet, which collates all Top 10 values from these multiple sheets pivot tables & Create a new table.
Is this possible to do, if so kindly help me out. your help would be really appreciated!
@RowdyBoy9 1. To find the difference in the dates it is as simple taking the difference between 2 Dates in Load Script: Date(Date_Field1,'MM/DD/YYYY')-Date(Date_Field2,'MM/DD/YYYY').
2. My recommendation for the second requirement is to create all Top 10 Values in the Script Editor itself and then bring them on the Final Sheet on the Front end.
But I would be eager to know how to resolve this otherwise from our Qlik experts.
Hi @sidhiq91 thank you for your response and recommendation, the challenge for me is to create that Top 10 values in load editor, Can you provide me with a sample script on creating a pivot table with filters.
For example:
I have a table, with different columns., loaded using load editor script, I need a pivot table like
(Excel Pivot Explanation): Rows Section (Name), Columns Section (Risk), Sum Values (Count of IDs), Filters (Task & Days).
Could you please provide me with sample script on Pivot table creation, so that i can apply the same for other pivots in my project.
