topic Re: Multiple field with count in one table in QlikView

Multiple field with count in one table

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

Hello,

So i have multiple field (Field1, Field2, Field3,... ). Each fild contain the same data. ( Value1, Value2, Value3,... )

I need to count each values.

Like:

Data	Field1	Field2	Field3
Value1	Count(field1)	Count(field2)	Count(field3)
Value2	Count(field1)	Count(field2)	Count(field3)
Value3	Count(field1)	Count(field2)	Count(field3)
Value4	Count(field1)	Count(field2)	Count(field3)
Value5	Count(field1)	Count(field2)	Count(field3)

How can i archive that ? With aggr()?

Thanks a lot

Re: Multiple field with count in one table

sunny_talwar — Wed, 08 Nov 2017 14:51:16 GMT

Not sure I understand your data... you have expressions in the fields?

Re: Multiple field with count in one table

Anil_Babu_Samineni — Wed, 08 Nov 2017 14:57:11 GMT

I am with sunny

Create Straight Table

Dimension - Data

Expressions - Count(Field1), Count(Field2), Count(Field3) // Three expressions

Re: Multiple field with count in one table

xiuur2508 — Thu, 09 Nov 2017 07:08:09 GMT

OK i will try to explain better ^^

I want to have the frequency of each values in eaach field.

Field1: Field2:

sun     5       50%                  sun     11       55%
star     4       40%                  star     2       20%
Moon 1    10%                     Moon 7      35%

I don't want to have multi field.
I want one table with all the field with frequency and percent. To extract all in excel in one time.

It's the same value in each field ( sun, star, moon, ... )

Re: Multiple field with count in one table

PrashantSangle — Thu, 09 Nov 2017 07:24:22 GMT

Hi,

Right Click on list box > property> general > Show Frequency > (If required in percent then select %)

If you required all 3 then

list box > property > Expression >

Add expression

1: count(FieldName)

2: sum(FieldName)/Sum(Total FieldName)

Regards,