Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Partner

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