topic Re: How to add Aggregate data in QlikView

How to add Aggregate data

Anonymous — Tue, 26 Jun 2018 12:49:21 GMT

hi，

I want to use aggregate row to distinct data in straight，just like bellow：

But i found the straight table's aggregate can't do this,it can't use expression to distinct repeating data。Column1 is a dimension,used and subtotal is expression.So i want to add a aggregate row at the bottom by using expression to distinct repeating data.

Am i right ? and Who can help me？

Thks

Re: How to add Aggregate data

sunny_talwar — Tue, 26 Jun 2018 16:33:15 GMT

What is the expressions for Used and subtotal here?

Re: How to add Aggregate data

Anonymous — Wed, 27 Jun 2018 01:39:11 GMT

hi,

used:a data field from raw table,

subtatol:sum(used)

Re: How to add Aggregate data

Anil_Babu_Samineni — Wed, 27 Jun 2018 01:50:57 GMT

I suggest you to use field in script like subfield(used) and used expression count(total <column1> distinct used)

Re: How to add Aggregate data

Anonymous — Wed, 27 Jun 2018 02:56:54 GMT

Re: How to add Aggregate data

Anonymous — Wed, 27 Jun 2018 02:57:58 GMT

Now i need to get the total and distinct repeating data,not the subtotal.

Re: How to add Aggregate data

ogautier62 — Wed, 27 Jun 2018 04:08:52 GMT

Hi,

use a sheet with column1 in dimension

in expression :

concat(used,',') to have 1,2,3,4

for total :

count(distinct used)

regards

Re: How to add Aggregate data

ogautier62 — Wed, 27 Jun 2018 04:16:42 GMT

and for expression total

use option "total of the expression" and not sum of rows

Re: How to add Aggregate data

Anonymous — Wed, 27 Jun 2018 04:38:19 GMT

hi,

Thks.

About:

for total :

count(distinct used)

is used for my subtotal ?

I'm new to qv, i have used a sheet with column1 in dimension, and have a expression by using concat(used,',') to have 1,2,3,4 , and use count expression to get avery row's subtotal number.

Now i want to get the aggergate total at the buttom. So, Where to be used this expression count(distinct used)?

Re: How to add Aggregate data

ogautier62 — Wed, 27 Jun 2018 10:59:51 GMT

add an expression, with option total and it will display total count

Re: How to add Aggregate data

Anonymous — Wed, 27 Jun 2018 14:17:51 GMT

hi，

Thank you！

If i add an expression ,iCan it be at the buttom ? Because i have other several expressions

Re: How to add Aggregate data

ogautier62 — Thu, 28 Jun 2018 07:22:54 GMT

either you add an expression in graph to have total,

either you put it under graph in a text box : count(total distinct used)

Re: How to add Aggregate data

Anonymous — Thu, 28 Jun 2018 08:00:10 GMT

Hi,

Thank you.

Can use rowno() to add a new row to get aggergae total at the bottom ?How to do this ?

I have a another question:

I have a user-defined format like -6ppt(s),can it be as

a negative number and be marked red automatic ？

Re: How to add Aggregate data

ogautier62 — Thu, 28 Jun 2018 08:42:53 GMT

no rowno() is not for that

if you don't want another expression use a text box with definition is : = count(total distinct used)

Re: How to add Aggregate data

ogautier62 — Thu, 28 Jun 2018 08:45:08 GMT

for color :

and in definition :

if(your expression <0,red())

Re: How to add Aggregate data

ogautier62 — Thu, 28 Jun 2018 10:15:23 GMT

in the screen "expression", here is to add general total of expression :

Re: How to add Aggregate data

Anonymous — Fri, 29 Jun 2018 00:09:55 GMT

HI，

Thank you.

Can the general total of expression in the screen "expression" be add this definition : count(total distinct used) ?

and if can,Where to add?

Re: How to add Aggregate data

ogautier62 — Fri, 29 Jun 2018 09:03:08 GMT

hi, just like this :

Re: How to add Aggregate data

Anonymous — Fri, 29 Jun 2018 12:15:21 GMT

hi，

Thank you.

It will be at the bottom?

i have several expressions ,so it can't be at the right .

Re: How to add Aggregate data

Anonymous — Mon, 02 Jul 2018 08:28:01 GMT

hi,

Are you here?