Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

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

Hi

first check ur data

and ur filter expression also

that exp is works

View solution in original post

13 Replies
ssriramin19
Contributor III
Contributor III
Author

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

Not applicable

hi

in chart write  distinct before your field.

ssriramin19
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Partner - Creator
Partner - Creator

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
Contributor III
Contributor III
Author

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
Partner - Creator II
Partner - Creator II

Hi

Try this

=

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



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

Regards

Kaushal Mehta

ssriramin19
Contributor III
Contributor III
Author

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

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