Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Category Name has to Change daily basis

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

CatIDProductRating
100Data Model5
100Scripting4.5
100UI5
100Functions5
105Power Pivot4
105Pover View5
105Mashup4
115SP3
115Triggers2
115Joins5

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

Output:

Capture.PNG

and tomorrow report this status should be changed.

let say tomorrow's report

CatIDProductRating
101Data Model5
101Scripting4.5
101UI3
102Functions2
102Tableau Ui3
102Scripting4
109SAS UI2
109SAS Scripting3
110SAP UI2
110SAP Concepts2

OutPut:

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

1.PNG

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

2 Replies
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Arthur_Fong
Partner
Partner

Try this:

MC.PNG

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