Expression that doesn´t aply listboxes - Qlik Community

Anonymous · ‎2016-12-02

Hello,

I am trying to do a graph where the sum total of month does not change when you are making selections in Listboxes.

Is is possible to do it?

adamdavi3s · ‎2016-12-02

You can use sum({1}yourcolumn)

{1} is the set analysis used to exclude any selection

Anonymous · ‎2016-12-02

If you have a specific listbox, you can do it as follows:

sum({< FieldListBox = >} FieldValues)

Anonymous · ‎2016-12-02

Perfect!!!

One more question. I have a the dimension month.

¿It is possible to make that it always stays the same? i mean not to filter it depending on the selections done?

thank you

Anonymous · ‎2016-12-02

It would be what Adan Davies passed:

sum({1} FieldValues)