topic Re: Is it possible to remove one value in listbox? in QlikView

Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 08:35:17 GMT

Hi~~i want to know that is it possible to remove "implemented" in the listbox of "Purpose".

Do i need to change in script? But in the script, it just show like this:

So, what should i do?

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 08:39:36 GMT

=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )

=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 08:39:38 GMT

use Where Condition

Table:

Loald *

From yourSource

Where Purpose <>'Implementation';

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 08:39:55 GMT

Just change your list box to use an expression, add the following as your expression =if(Purpose <> 'Implementation', Purpose)

Re: Is it possible to remove one value in listbox?

manideep78 — Tue, 15 Apr 2014 08:40:08 GMT

Use where Clause in the script :

WHERE Purpose <> 'Implementation'

Use Expression in List Box:

=if(Purpose<>'Implementation',Purpose)

Re: Is it possible to remove one value in listbox?

its_anandrjs — Tue, 15 Apr 2014 08:40:24 GMT

Yes in list box in expression type like this

In Front use like

If(Purpose='Recovery','Recovery',

If(Purpose='User Request','User Request'))

Or you can write in list box expression

If(Purpose <>'Implementation',Purpose)

3.In the load script like

Load

Fields

From Location

Where Purpose <>'Implementation';

Regards

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 08:57:54 GMT

Go to list Box and then in general tab in drop down go to expression and then in expression you have to write this

=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )

=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 08:58:39 GMT

Thank u for ur help! But it's not correct.May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 09:00:47 GMT

Thanks! But it doesn't work. May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"

Re: Is it possible to remove one value in listbox?

manideep78 — Tue, 15 Apr 2014 09:11:21 GMT

Take Month as Dimesion and take two expressions:

Count({<Purpose={'Recovery'}>}Purpose)

Count({<Purpose={'User Request'}>}Purpose)

Re: Is it possible to remove one value in listbox?

its_anandrjs — Tue, 15 Apr 2014 09:24:21 GMT

In expression write your expression like

Count({<Purpose = {'Recovery','User request' >}Your sum or count Value)

If use in dimension then write calculated dimension for Purpose

=If(Purpose='Recovery','Recovery',

If(Purpose='User Request','User Request'))

=If(Purpose <>'Implementation',Purpose)

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 09:32:43 GMT

use this in chart dimension

=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )

or if(Purpose='Implementation','',Purpose)

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 09:45:07 GMT

I did the way u taught, but i also want to remove implemented char.

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 09:48:53 GMT

Can u share the image after implementing my script and please clear what exactly you want

Re: Is it possible to remove one value in listbox?

jagan — Tue, 15 Apr 2014 09:50:19 GMT

Hi,

Try like this

Count({<Purpose = {'Recovery','User Request' >} MeasureName)

Sum({<Purpose = {'Recovery','User Request' >} MeasureName)

Regards,

Jagan.

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 09:52:48 GMT

I want to remove the chart of implemented(the red color one)

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 09:53:49 GMT

whats you expression can u share me

Re: Is it possible to remove one value in listbox?

arsal_90 — Tue, 15 Apr 2014 09:54:17 GMT

can u post your qvw

Re: Is it possible to remove one value in listbox?

Tue, 15 Apr 2014 10:00:15 GMT

Re: Is it possible to remove one value in listbox?

jagan — Tue, 15 Apr 2014 10:10:23 GMT

Hi,

Did you tried filtering using Set Analysis instead Dynamic Dimensions like this

Count({<Purpose = {'Recovery','User Request' >} MeasureName)

Sum({<Purpose = {'Recovery','User Request' >} MeasureName)

Regards,

Jagan.