Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mg862925
New Contributor

specific value in KPI

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

 

2 Replies
Partner
Partner

Re: specific value in KPI

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")

Capture.PNG

mg862925
New Contributor

Re: specific value in KPI

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]);