topic Re: Fixed Total in QlikView

Fixed Total

zet — Sat, 16 Nov 2024 17:49:21 GMT

Hello,

I have a table with 3 dimensions (Dim1, Dim2,Dim3)

I want to show a table containing :

1st column : count(Aggr(count(*),Dim1,Dim2,Dim3))

2nd column : count(Aggr(count(*),Dim1,Dim2)) => wich is a total fixed value that I will use in calculating other dimensions

Finally I want something like this

Dim1	Dim2	Dim3	Total
Line1	Line1	Line1	FixedTotal
Line2	Line2	Line2	FixedTotal

Thanks in advance for your help !

Re: Fixed Total

Anil_Babu_Samineni — Mon, 16 Nov 2020 16:56:11 GMT

Please post some rows of data to understand more clear

Re: Fixed Total

zet — Mon, 16 Nov 2020 17:48:19 GMT

Number	Place	Type	Technique
1	1	D	G
1	1	D	L
1	2	P	G
1	2	P	L
1	3	A	G
1	4	A	G

I count Technique rows like that : count(Aggr(count(*), Number, Place, Type, Technique))

Technique

Nb Technique

count(Aggr(count(*), Number, Place, Type, Technique))

Total

count(Aggr(count(*),Number,Place,Type))

I want to calculate total this way : count(Aggr(count(*),Number,Place,Type)) without considering Technique and it should be the same value for all the rows

In our example Total should be = 4 and not 6

Re: Fixed Total

Anil_Babu_Samineni — Mon, 16 Nov 2020 17:55:52 GMT

One more thing, Why you want to exclude "L" from technique to the total, Any logic behind?

Re: Fixed Total

zet — Mon, 16 Nov 2020 18:33:00 GMT

We can consider fields Number,Place,Type as a Place ID and Technique as signal techniques that covers places

so to count the total number of places covered by any signal we should count only occurences by Number,Place,Type

=> Total Number of places=4

=> G=4/4 = 100%

=>L=2/4=50%

Re: Fixed Total

Anil_Babu_Samineni — Mon, 16 Nov 2020 18:49:55 GMT

If i understand correctly, Try this way

Count(Aggr(Count(Technique), Number, Place, Type))

Re: Fixed Total

zet — Mon, 16 Nov 2020 19:21:01 GMT

Yes that's how I count Total but I want to make it as a fixed value in all rows so in the same table I want to have 2 different expressions :

Expression 1: Count(Aggr(Count(Technique), Number, Place, Type, Technique))

Expression 2 : Count(Aggr(Count(Technique), Number, Place, Type)) => Fixed TOTAL

but it doesn't work

Re: Fixed Total

Anil_Babu_Samineni — Mon, 16 Nov 2020 19:39:23 GMT

You should use TOTAL keyword for outer analysis

Count(TOTAL Aggr(Count(Technique), Number, Place, Type))

Re: Fixed Total

zet — Mon, 16 Nov 2020 20:32:16 GMT

Works perfectly. Thanks !!!