topic Re: Coloring/Concatenating different Calculation in single column in QlikView

Coloring/Concatenating different Calculation in single column

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to calculate come counts of seviority and trying to display in same column.

For instance have to count seviority by Column1

Output:

C1	Count of Seviority (High/Med/Low)
A	1/1/0
B	2/1/2
C	0/0/1
D	3/0/0

And display like this

Table A

adamdavi3s — Thu, 08 Dec 2016 10:29:19 GMT

AFAIK the only way to do this would be to have three different expressions and colour them

sunny_talwar — Thu, 08 Dec 2016 10:33:06 GMT

I don't think coloring can work, but concatenation should be simple I think

Script:

LOAD C1,

Dual(seviority, Match(seviority, 'High', 'Med', 'Low')) as seviority

and then on the front end

Dimension:

Expression:

Concat(Aggr(Count(seviority), c1, seviority), '/', -seviority)

adamdavi3s — Thu, 08 Dec 2016 10:35:16 GMT

Something like this is possible if you need colour coding, but you'll have to decide between having it all in one cell or having colours I am afraid!

adamdavi3s — Thu, 08 Dec 2016 10:36:57 GMT

Another way without changes to the script is a simple

=sum(if(seviority='High',1,0)) &'\'&sum(if(seviority='Med',1,0)) &'\'&(if(seviority='Low',1,0))

dsharmaqv — Thu, 08 Dec 2016 12:38:46 GMT

I have tweeked a bit to avoid color coding

sum(if(seviority='High',1,0)) &'(H)\'&sum(if(seviority='Med',1,0)) &'(M)\'&sum(if(seviority='Low',1,0)) &'(L)