Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Static values

Hi All,

@sunny_talwar  @tresesco 

i want to show the top customers  ( these are fixed customers ) in stright table how to show?

the list mentioned in text object.   8 customers only should show in table with amount .

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

14 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

Using Set Analysis?
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...

Something like...
sum( {<Account={'Limagrain','BOBST'}>} Amount1)
soniasweety
Master
Master
Author

i cant use this in set analysis.

 

because that list i want to see as dimension in the table aslo

Frank_Hartmann
Master II
Master II

see attached.

hope this helps

soniasweety
Master
Master
Author

thank you @Frank_Hartmann   but.   i dont want other account names in the strihgt table

i want to show only listed customers only.

Frank_Hartmann
Master II
Master II

see attached

soniasweety
Master
Master
Author

Hi @Frank_Hartmann 

in my dashboard i have script like this  

how can i incorporate with applymap 😞

Table:
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Total,
Source,
FROM
$(vQvdPath)/Orders.qvd
(qvd) where Source<>'FA';

LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Total,
Source,
FROM
$(vQvdPath)/orders.qvd
(qvd) where Source='FA';

Frank_Hartmann
Master II
Master II

Map:
Mapping Load * Inline [
Account, Number
Limagrain,1
BOBST,2
FESTO,3
SGL Carbon,4
3M,5
ABB,6
Accenture,7
ADVENTIST HEALTH SYSTEM,8
AGILENT TECHNOLOGIES,9
];


Table:
LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Applymap('Map',Account,Null()) as Flag,
Total,
Source
FROM
$(vQvdPath)/Orders.qvd
(qvd) where Source<>'FA';

LOAD BAC,
upper(REGION) as REGION,
CountryName,
Account,
Applymap('Map',Account,Null()) as Flag,
Total,
Source
FROM
$(vQvdPath)/orders.qvd
(qvd) where Source='FA';
soniasweety
Master
Master
Author

Thank you so much. let me  check and come back  🙂

Akhil_Reddy
Contributor III
Contributor III

USE THIS AS CALCULATED DIMENSION----

=IF(MATCH(Account,'ABB','Accenture','ADVENTIST HEALTH SYSTEM','Limagrain','BOBST','FESTO','SGL Carbon','3M','AGILENT TECHNOLOGIES'),Account,NULL())

USE THIS IN EXPRESSION--------

IF(SUM(Amount1)>0,SUM(Amount1),'-')

-------------------

IT ONLY WORKS IF U HAVE 1 DIMENSION I.E ACCOUNT IN STRAIGHT TABLE