topic Re: Before Selection and After Selection value Changes in QlikView

Before Selection and After Selection value Changes

Mon, 23 Mar 2015 08:53:26 GMT

Hi All,

i have a prob, when calculating summations the values changes reason why i don't know, as i request help:

before selection:

Teachers	Students	Visit
Teacher A	Student A	2
Teacher A	Student B	1

after selection

Output:

Teachers	Students	Visit
Teacher A	Student A	0
Teacher A	Student B	1

How can i resolve this on Student A?

Regards.

Re: Before Selection and After Selection value Changes

tresB — Mon, 23 Mar 2015 08:56:35 GMT

Without knowing your app, it would be wild guess. Try to share your sample app.

Re: Before Selection and After Selection value Changes

sushil353 — Mon, 23 Mar 2015 09:01:50 GMT

Hi,

Say you are calculating some expression Sum(Value)

then try like this = sum({<Teachers=, students=>}Value)

HTH

sushil

Re: Before Selection and After Selection value Changes

richard_chilvers — Mon, 23 Mar 2015 09:04:47 GMT

Its hard to say without seeing your model. My suggestion is to look carefully at how your data has been constructed in the script. This may lead to unexpected results when you make selections (depending on the field you're selecting).

Regards

Re: Before Selection and After Selection value Changes

Anonymous — Mon, 23 Mar 2015 10:11:36 GMT

you can use 2 solution

refer to super set if you dont at all want any selection to change this chart numbers

you can add set analysis to your aggregate function

=count( {1} visitid)

and if you want just want particular field selection should not change the chart numbers then

you can use as follows

=count( {<Field1=,Field2=>} visitid)

Re: Before Selection and After Selection value Changes

Mon, 23 Mar 2015 10:15:51 GMT

Hi Bhagirath,

Here is my code it dosen't seem to work:

=sum(aggr(count(DISTINCT SalesDate),CustomerCode))

Regards.

Re: Before Selection and After Selection value Changes

Anonymous — Mon, 23 Mar 2015 11:39:01 GMT

=sum(aggr(count({1}DISTINCT SalesDate),CustomerCode))

you can refer to the community link below for more details on Aggr functuion

Aggr() function

regards,

Bhagirath

Re: Before Selection and After Selection value Changes

awhitfield — Mon, 23 Mar 2015 11:51:26 GMT

What exactly do you mean by 'before selection' and 'after selection? What are you selecting?

Andy

Re: Before Selection and After Selection value Changes

Mon, 23 Mar 2015 11:54:12 GMT

Hi Andrew,

when trying to select on a Teacher.

the value on my Visits Changes as shown.

Re: Before Selection and After Selection value Changes

awhitfield — Mon, 23 Mar 2015 11:55:53 GMT

Can you post your app please?

Andy