topic Re: list box selection in QlikView

list box selection

ssriramin19 — Mon, 26 Jan 2026 18:19:17 GMT

Hello ,

My requirement is that I have a list box.Whenever I select any values in list box the values in the chart should not get affected .Can anyone suggest me how to implement the change in front end in chart so that selections do not affect.

Thanks

Sriram

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 07:29:54 GMT

Can anyone tell me how to resolve the above error.It is bit urgent.

Re: list box selection

Wed, 09 Jan 2013 07:34:49 GMT

in chart write distinct before your field.

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 07:40:42 GMT

I tried with distinct keyword ,but it is not workigng properly.Selection made in the list box should not change the pivot table values.

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 07:40:45 GMT

I tried with distinct keyword ,but it is not workigng properly.Selection made in the list box should not change the pivot table values.

Re: list box selection

hschultz — Wed, 09 Jan 2013 07:48:45 GMT

Can you please post a sample of what you are trying to achieve?

I am sure Set Analysis will do the trick, but i need to be certain how you want to do it?

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 08:07:07 GMT

My expression in pivot table is

=NUM(Sum(Distinct([Supply Plan])))

& if(Plan_For_Month >=monthstart(today()),Sum(([Supply Plan 1])))

and the dimension used in pivot table is

=Date(Plan_Made_Date,'MMM YYYY') and =Date(Plan_For_Month,'MMM YYYY')

I have field called lag which has values 0,1,2,3 which is calculated on the back end. Requirement is whenever I select any values for lag the values in pivot table should not change.

Thanks

Re: list box selection

kaushalview — Wed, 09 Jan 2013 08:13:52 GMT

Try this

NUM(Sum(Distinct{$<FeildName>}([Supply Plan])))

& if(Plan_For_Month >=monthstart(today()),Sum(({$<Feildname>}[Supply Plan 1])))

Regards

Kaushal Mehta

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 08:21:35 GMT

when I tried the above expression I am getting error in expression

=NUM(Sum(Distinct{$lag}([Supply Plan])))

& if(Plan_For_Month >=monthstart(today()),Sum(({$lag}[Supply Plan 1])

can you please advise how to rewrite the above expression without error

Re: list box selection

Wed, 09 Jan 2013 08:22:15 GMT

Use {1} in ur expression

i gives all the values if u select the values in the list box

try this sample

sum({1}amount) likethis

=NUM(Sum({1}Distinct([Supply Plan])))

& if(Plan_For_Month >=monthstart(today()),Sum(({1}[Supply Plan 1])))

try this

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 08:30:46 GMT

The values are getting changed in the pivot table if the above expression is being used.

is htere anyother method to resolve the above problem

Thanks

Re: list box selection

Wed, 09 Jan 2013 08:45:24 GMT

Try this expression it works

num(sum({1<Plan_For_Month={">=$(=monthstart(todate()))"}>}[Supply Plan]))

Re: list box selection

ssriramin19 — Wed, 09 Jan 2013 08:51:46 GMT

the above two expression works but the values of december 2012 and jan 2013 does not appear in the pivot table which should be present even after lag selection is made in the list box.

How to resolve now.

Re: list box selection

Wed, 09 Jan 2013 09:02:22 GMT

first check ur data

and ur filter expression also

that exp is works