How to get Top 10 Values from multiple pivot tables in different sheets and create a new table with the result

[RowdyBoy9]

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!

[sidhiq91]

@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.

[RowdyBoy9]

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.