topic Re: Use a variable into set analysis expression - Help! in QlikView

Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 17:19:15 GMT

Hello my friends,

I've the variable vFiltro

vFiltro = GetFieldSelections(Fato)

And I wrote this set analysis expression:

=Count({$<Fato={'$(vFiltro)'}>} DISTINCT %IDSalesForce)

When selected one value in my listbox 'Fato'..., display '0' when the expected is 688.

Why? Thanks

Re: Use a variable into set analysis expression - Help!

ashfaq_haseeb — Fri, 17 Oct 2014 17:20:56 GMT

Hi,

may be try like this

=Count({$<Fato={'$(=vFiltro)'}>} DISTINCT %IDSalesForce)

Regards

ASHFAQ

Re: Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 17:28:11 GMT

Hi Ashfaz!

But i try this...

And doesn't work

Re: Use a variable into set analysis expression - Help!

ashfaq_haseeb — Fri, 17 Oct 2014 17:31:29 GMT

Hi,

Can you post sample application

Regards

ASHFAQ

Re: Use a variable into set analysis expression - Help!

JonnyPoole — Fri, 17 Oct 2014 17:32:37 GMT

Does Fato have spaces in it ? in your example, if you put the following in a text box, what is the result"

=GetFieldSelections(Fato)

You may need to use =GetFieldSelections(Year,chr(39)&','&chr(39))

which would give this which is needed for certain values in a modifier..

My town','your town','two words','oneword

Re: Use a variable into set analysis expression - Help!

maxgro — Fri, 17 Oct 2014 17:35:30 GMT

if you make a textbox with

=GetFieldSelections(Fato)

what is the result in textbox?

Re: Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 17:55:10 GMT

I made a example...

When i select one Product in my listbox, i want to see the sum minus the item selected in my list box 'Produtos'.

In the text box yellow, have the code:

=Sum({<Produto=E({1<Produto={'=GetFieldSelections(Produto)'}>})>} x )

But it doesn't work...

Why?

Re: Re: Use a variable into set analysis expression - Help!

ashfaq_haseeb — Fri, 17 Oct 2014 18:09:17 GMT

Hi,

For selections try this

=Sum({<Produto={'$(=vTest)'}>}x)

For inverse selection try this

=Sum({1-$<Produto={'$(=vTest)'}>}x)

Have a look at attached application

Regards

ASHFAQ

Re: Re: Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 18:10:10 GMT

Yep!

Re: Re: Use a variable into set analysis expression - Help!

ashfaq_haseeb — Fri, 17 Oct 2014 18:11:42 GMT

Hi,

If it answered, can you close this thread by selecting appropriate answers?

Regards

ASHFAQ

Re: Re: Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 18:15:11 GMT

Fato is a list box.

In this list box contains:

'Contac Center', 'Promo Digital', 'SMS'.

If I choose 'SMS' in this listbox, in my text box with the code 'GetFieldSelections(Fato)', the result is 'SMS'.

Re: Use a variable into set analysis expression - Help!

ashfaq_haseeb — Fri, 17 Oct 2014 18:21:42 GMT

you can even use this to exclude

Sum({<Produto=e(Produto)>}x)

did you check my attached file

Regards

ASHFAQ

Re: Use a variable into set analysis expression - Help!

Fri, 17 Oct 2014 18:28:24 GMT

Now is correct!

Thanks!