topic Re: Dont see Variable result unless i select a row in QlikView

Dont see Variable result unless i select a row

Sun, 21 Jun 2015 17:09:04 GMT

I everybody,

Today i have spécial problem with qlikview, i explain :

i add fews variables in my qvw, and i use one as expression in a straight table, but the problem is that i see the result of the ''Variable'' only when i Select a row.

To summarize, i have a two columns straight table i have i have allways "0" in my second columns( who containt my variable) unless i select one row of the table

Somebody have a solution??

Thanks

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 17:11:01 GMT

What's the definition of your variable? And which dimensions are used in your chart?

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 17:29:56 GMT

here is the definition of my variable :

if($(#DSnbD)='Oui','Oui',if($(#DSCB)='Oui','Oui',if($(#DSEND)='Oui','Oui',if($(#DSnbD)='Non' and $(#DSCB)='Non' and $(#DSEND)='Non','Non',if($(#DSnbD)='NC','Non')))))

and my dimension is just i field of my excel files, and for each dimension i need the result of my varible. But it's allways "0" unless i select one row

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 17:36:19 GMT

It's hard to help you without knowing the field names used as dimensions and the definition of the variables used in your above expression.

It may be easier if you upload your sample QVW to this thread (upload is available in advanced editor).

In general, each field in your expression should be either embedded in an aggregation function, or should be a field used in a dimension. If there's no unambiguous evaluation of the expression, it will return NULL (not zero, and I currenctly don't understand why your above expression should return zero).

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 18:01:40 GMT

Thanks you very much for your helps,

Here is my straight table the field ''EEEE'' is the one who containt my variable and it allways show zero before i selcted a row

now what happen when i selelect a row i get the result on field ''EEEE'' like u can see :

and the ''EEEE' containt my variable :

i would like to share the qvw with you but my company wnt all confidencial, hope u w'ill understand. Thanks a lot ;

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 18:04:55 GMT

Yes, I understand that you can't upload your original QVW.

But I still understand how your expression you posted above:

if($(#DSnbD)='Oui','Oui',if($(#DSCB)='Oui','Oui',if($(#DSEND)='Oui','Oui',if($(#DSnbD)='Non' and $(#DSCB)='Non' and $(#DSEND)='Non','Non',if($(#DSnbD)='NC','Non')))))

should return zero or 1. I may miss something, but possible return values are 'Oui' or 'Non', right?

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 18:13:35 GMT

in fact my variable depend on other variable and the result is the number of ''Oui'' of a other variable, you understand more now?

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 18:21:54 GMT

Ok, so there is probably a COUNT() function involved somewhere.

As I said it's almost impossible to help without a minimum if information provided.

I would assume that you evaluate fields not embedded in an aggregation function and that this can't be evaluated correctly until you limit the context in a way that there is only one possible return value left, e.g. by a selection in field ZZZZ.

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 18:26:19 GMT

yes i have the count function, what do you mean by use of aggregation??

thanks

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 18:33:39 GMT

Here is more details, i review my sintat and my varible return ''Oui'' or ''Non'' and the 'EEEE' fields containt : count({<Poche={"=$(#POC)='Oui'">} Poche)

And $(#POC) is my variable , and poche is that field from my excel wicch containt 'Oui' or 'Non'

Thanks

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 18:51:24 GMT

In an input box, what does your variable show when nothing is selected?

How is your variable defined?

Re: Dont see Variable result unless i select a row

Sun, 21 Jun 2015 18:58:28 GMT

My variable always show ''0'', its seem like qlikview make the calcul of my variable only when i select a row

Re: Dont see Variable result unless i select a row

swuehl — Sun, 21 Jun 2015 19:03:22 GMT

No, I rather think that your are missing proper aggregation. See the blogs I referenced above for more details.

I think I can't add anything more with the information provided.