Static values

[soniasweety]

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 .

[Carlos_Reyes]

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]

i cant use this in set analysis.

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

[Frank_Hartmann]

see attached.

hope this helps

[soniasweety]

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]

see attached

[soniasweety]

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]

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]

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

[Akhil_Reddy]

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