topic Re: Static values in QlikView

Static values

soniasweety — Sat, 16 Nov 2024 20:23:49 GMT

Hi All,

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 .

Re: Static values

Carlos_Reyes — Tue, 23 Jul 2019 22:20:52 GMT

Using Set Analysis?
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

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

Re: Static values

soniasweety — Wed, 24 Jul 2019 07:14:12 GMT

i cant use this in set analysis.

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

Re: Static values

Frank_Hartmann — Wed, 24 Jul 2019 07:57:27 GMT

see attached.

hope this helps

Re: Static values

soniasweety — Wed, 24 Jul 2019 08:19:06 GMT

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

i want to show only listed customers only.

Re: Static values

Frank_Hartmann — Wed, 24 Jul 2019 08:25:27 GMT

see attached

Re: Static values

soniasweety — Wed, 24 Jul 2019 09:19:28 GMT

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';

Re: Static values

Frank_Hartmann — Wed, 24 Jul 2019 09:24:21 GMT

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';

Re: Static values

soniasweety — Wed, 24 Jul 2019 09:26:40 GMT

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

Re: Static values

Akhil_Reddy — Wed, 24 Jul 2019 10:08:15 GMT

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

Re: Static values

soniasweety — Thu, 25 Jul 2019 06:37:04 GMT

Hi @Frank_Hartmann there is one more catch

user has given other dimension Account1 with two values

Account1

axa

numeo

he want to show this dimension also in the stright table how can i include this dimension values in applymap?

Re: Static values

Akhil_Reddy — Thu, 25 Jul 2019 07:18:41 GMT

USE THIS CALCULATED DIMENSION ON FIELD 2---------------------->

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

NOW U GET 8 VALUES FROM DIM 1 AND U GET VALUES IN DIM 2 WHICH ARE ASSOCIATED WITH DIM 1

Re: Static values

Frank_Hartmann — Thu, 25 Jul 2019 07:30:14 GMT

showing only the 2 Accounts in straight table?

Add the 2 Accounts to your Mapping table like this

(Note: QV is Case sensitive. You need to exactly match the notation of your source file for field Account)

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 Axa,10 Numeo,11 ];

As dimensions just use:

=if(Flag=10 or Flag =11,REGION,Null()) =if(Flag=10 or Flag =11,Account,Null())

Re: Static values

soniasweety — Thu, 25 Jul 2019 07:34:51 GMT

Hi @Frank_Hartmann sorry you miss undestood my question 😞

i need to add one more dimension along with first dimension aswell

Account i need to show 8 customernames in account1 i need to show only 2 customers names in stright table

Re: Static values

Frank_Hartmann — Thu, 25 Jul 2019 07:55:04 GMT

see attached