topic Re: need help with set analysis in QlikView

need help with set analysis

Thu, 16 Apr 2015 11:57:28 GMT

i have a field using dual function,

and i have created a toggle button - (i checked its behavior it is working fine with number i.e.1,0 not with the string)

now the problem in set analysis when i use

{<num(field)={'variable'}>}

please find attached document

Re: need help with set analysis

Anonymous — Thu, 16 Apr 2015 12:02:10 GMT

Far easier to use the text values for a dual(), and set vShowDev to U or whatever text value you need.

count({<Bulk_Flag={'$(vShowDev)'}>}Bulk_Flag)

Re: need help with set analysis

Thu, 16 Apr 2015 12:05:06 GMT

the problem is that other value have space in string "N U"... and in second value i want to pass 'U','N U'

how can i handle this?

Re: need help with set analysis

Thu, 16 Apr 2015 12:07:07 GMT

and as i told button is not behaving good when i use if(vShowDev=0,'U','N U')

with this, button is worked for one time only

Re: need help with set analysis

sunny_talwar — Thu, 16 Apr 2015 12:10:42 GMT

Tried using the if?

=Count(If(Bulk_Flag = vShowDev, Bulk_Flag))

Best,

Sunny

Re: need help with set analysis

Anonymous — Thu, 16 Apr 2015 12:11:09 GMT

count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"}>} Bulk_Flag)

Re: need help with set analysis

sunny_talwar — Thu, 16 Apr 2015 12:11:40 GMT

PFA the application.

Best,

Sunny

Re: need help with set analysis

Thu, 16 Apr 2015 12:14:43 GMT

Hi Michael ,urs idea is working ...

can u please explain me the logic

Re: need help with set analysis

Thu, 16 Apr 2015 12:19:00 GMT

Hi Gurjeet,

PFA application.

Hope u are looking the same.

Thanks,

Ashok.

Re: need help with set analysis

Anonymous — Thu, 16 Apr 2015 12:22:01 GMT

It is not allowed to use functions here:

{<num(field)={'variable'}>}

It must always be field name:

<field={something}>}

Now, replace "something" with any expression you may need, in this case:

<field={"=num(Bulk_Flag)=$(vShowDev)"}>}"}>}

Re: need help with set analysis

Thu, 16 Apr 2015 12:24:55 GMT

help me out more ---

button = 0

show only U value

button = 1

show both 0(N U) and 1(U) values

Re: need help with set analysis

sunny_talwar — Thu, 16 Apr 2015 12:27:24 GMT

Right now it is not showing both when variable = 1, do you want it to show both??

Best,

Sunny

Re: need help with set analysis

Thu, 16 Apr 2015 12:28:23 GMT

yes

Re: need help with set analysis

sunny_talwar — Thu, 16 Apr 2015 12:30:16 GMT

Try this as your expression:

=Count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"} + {"=num(Bulk_Flag)=0"}>} Bulk_Flag)

Re: need help with set analysis

Thu, 16 Apr 2015 12:32:53 GMT

thanks alot

Re: need help with set analysis

sunny_talwar — Thu, 16 Apr 2015 12:33:37 GMT

Not a problem.

Sunny