Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a KPI for a specifik value in "Store Name" (See csv file)
Today I can see all the different stores by name but I want to create a specific group
All the name that starts with Telenor is Group Telenor
All the name that starts with El is group Elgiganten
All the name starts with Media is group Media Markt.
I want to display how many "Quoted IMEI" has Elgiganten made
How many "Quoted IMEI" has Media Markt made
How many "Qouted IMEI" has Telenor made
Today I can only show the specific store name
In the script:
create a new field:
LOAD
if("Store Name" like 'Telenor*','Group Telenor',
if("Store Name" like 'El*','group Elgiganten',
'group Media Markt')) as Group,
"Store Name",
"Tracking ID",
"Inspected Grade",
Status
FROM [lib://DATA_SOURCES/qlikforum1.xlsx]
(ooxml, embedded labels, table is [Telenor weekly aggregate report]);
Then create any u chart u want:
as dimension: Group
As a measure: count("Store Name")
I cant the correct numbers.
I get
- 489 this I do not understand why I get
Elgiganten 854
Media Markt 190
Telenor 5754
According to me it should be
Elgiganten 1097
Media Markt 339
Telenor 21736
See my CSV file
I loaded this
LOAD
if([Store Name] like 'Telenor*','Telenor',
if([Store Name] like 'El*','Elgiganten',
'Media Markt')) as Group,
[Store Name],
[Tracking ID],
[Inspected Grade],
[Status]
FROM [lib://AttachedFiles/Telenor Weekly Aggregate Report.xlsx]
(ooxml, embedded labels, table is [Telenor weekly aggregate report]);