Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ssriramin19
New Contributor II

list box selection

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

1 Solution

Accepted Solutions
Not applicable

Re: list box selection

Hi

first check ur data

and ur filter expression also

that exp is works

13 Replies
ssriramin19
New Contributor II

Re: list box selection

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

Not applicable

Re: list box selection

hi

in chart write  distinct before your field.

ssriramin19
New Contributor II

Re: list box selection

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

ssriramin19
New Contributor II

Re: list box selection

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

hschultz
Contributor

Re: list box selection

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?

ssriramin19
New Contributor II

Re: list box selection

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

kaushalview
Contributor II

Re: list box selection

Hi

Try this

=

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



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

Regards

Kaushal Mehta

ssriramin19
New Contributor II

Re: list box selection

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

  

Not applicable

Re: list box selection

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

Community Browser