Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator
Creator

Data model assistance

Hi,

I am sharing an excel having my query for reference. 

I need to assign the measure at month year level to supplier.But it's getting total to all like below.

 

Krish2459_58_0-1695092140860.png

Thanks..

Labels (1)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

you need to split up the MonthYear_CFM into 2 separate fields. Month and Year

you can do this via the Datamanager or via the dataload script.

I myself prefer the dataload script. there you can add this to the load statement when loading in the table

Load *
     subfield(MonthYear_CFM,' ', 0) as Month,
     subfield(MonthYear_CFM,' ', 1) as Year
From [LOCATION]

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFuncti... 

then you  can create 2 tables with

1. Supplier_Name, Month, count(DateType_CFM)

2. Supplier_Name, Year, count(DateType_CFM)