How to obtain a list from qlik instead of whats in the field selection

[tinkerz1]

Hi,

The below formula works for an enable condintional show because both sides of the equation are clicked green.

What I really would like is Issue - Locationfull to be the list inside the field, so when it is not clicked it will look inside the field at the list.

Reall stuck..

=

concat(distinct [Issue - Location],',')<>concat(distinct [Issue - Locationfull],',')

[miguelbraga]

Hi Neil,

Can you post some snapshots and/or the qvw file so that we can take a look and provide you a solution?

Regards,

Miguel

[swuehl]

What I really would like is Issue - Locationfull to be the list inside the field, so when it is not clicked it will look inside the field at the list.

Reall stuck..

=

concat(distinct [Issue - Location],',')<>concat(distinct [Issue - Locationfull],',')

Sorry, I don't understand.

Could you give an explanation with some sample lines of data? Or post a small sample QVW together with your expected result?

[tinkerz1]

I think my data model is wrong in the first place.

What I am trying to do is if individual countries are selected then produce a concat distinct string, then if that string matches in the CountryGroup list bring back those figures and summarize the individual totals.

I think I need 2 seperate totals for this too work as one click on countries is removing the country groups.

How would you structure the data?

[roger_stone]

Neil

Have a look at Alternate States as that may help solve your problem.

Roger

[#6]

I am not sure I understand but look at utilizing either set analysis, where you can code your expressions based on conditons, or possibly alternate states, where you can have certain slection critieria only affect certain objects.

If you can post something visual to explain what you are trying to accomplish, if towuld be of greate assistance