Data model assistance

[Krish2459_58]

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.

Thanks..

[MartW]

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)