Category Name has to Change daily basis

[qv_testing]

Hi Community,

I have one scenario,

Sales report - Every day I'm getting new file, each file has different CATID and based on Catid - Category should be align.

Suppose today's report..

CatID	Product	Rating
100	Data Model	5
100	Scripting	4.5
100	UI	5
100	Functions	5
105	Power Pivot	4
105	Pover View	5
105	Mashup	4
115	SP	3
115	Triggers	2
115	Joins	5

Here, These ID's 100, 105, 115 - associated with Power BI, Qlikview and SQL Server.

Output:

and tomorrow report this status should be changed.

let say tomorrow's report

CatID	Product	Rating
101	Data Model	5
101	Scripting	4.5
101	UI	3
102	Functions	2
102	Tableau Ui	3
102	Scripting	4
109	SAS UI	2
109	SAS Scripting	3
110	SAP UI	2
110	SAP Concepts	2

OutPut:

101, 102, 109 and 110 Catid's associated with Qlik Sense, SAP BO, SAS and Tableau

Please note Category table using as Inline table in Qlikview.

Please find attached folder - have 2 folders 10 and 11 - if I get 12th folder coming days that should be latest report as Category.

Hope you understand

Thanks in Advance

[Brett_Bleess]

Best I can offer is the following Design Blog post that may help:

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

Regards,
Brett

[Arthur_Fong]

Try this:

You have to assign a date (eg: SCDDate) each time you load a new Excel file. 

In this sample i'm using today() and today()-1 as SCDDate.

Select the date you want to view for Current Category.

The Previous Category will reflect as max(Date)-1.

Refer attached qvw as reference.

Thanks and regards,

Arthur Fong