topic Re: Formulas with two alternate states in QlikView

Formulas with two alternate states

Mon, 24 Feb 2014 11:11:24 GMT

Hello Guys,

I have these formulas, where the field "OPTIONAL" comes from a different alternate state called "State10"

=Chr(39)&Replace(GetFieldSelections(OPTIONAL,',', GetSelectedCount(OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

how do I add the alternative state to this formula???

Thank you already

Re: Formulas with two alternate states

Mon, 24 Feb 2014 11:13:10 GMT

state_name::field_name

Re: Formulas with two alternate states

Mon, 24 Feb 2014 11:17:32 GMT

If I go like this:

=Chr(39)&Replace(GetFieldSelections(State10::OPTIONAL,',', GetSelectedCount(State10::OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

The expression appears to be wrong, what should I do?

Re: Formulas with two alternate states

Mon, 24 Feb 2014 11:20:46 GMT

Try this:

=Chr(39)&Replace(GetFieldSelections([State10]::OPTIONAL,',', GetSelectedCount([State10]::OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

Don't worry if it's not parsing, it just happens sometimes with set analysis

Re: Formulas with two alternate states

Mon, 24 Feb 2014 11:40:17 GMT

Tried with the error but ended up still not working.

Re: Formulas with two alternate states

sbaldwin — Mon, 24 Feb 2014 12:01:09 GMT

Hi, i don't think you can use the state::field syntax with this system function, have you tried something like

=replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39))

Thanks

Steve

Re: Formulas with two alternate states

simondachstr — Mon, 24 Feb 2014 12:11:57 GMT

You can't use set analysis with the GetFieldSelections() function. Use an embedded Only function instead e.g.:

GetFieldSelections(Only({State10} OPTIONAL)) etc...

Re: Formulas with two alternate states

Mon, 24 Feb 2014 12:23:10 GMT

It worked perfectly buddy, however, the list starts with all OPTIONALS selected, and I need that to start 'blank', with no selections at the beginning.

Is that possible?

Re: Formulas with two alternate states

sbaldwin — Mon, 24 Feb 2014 12:33:00 GMT

Try:

=if(count({1} OPTIONAL) = count({State10} OPTIONAL),'blank', replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39)))

Re: Formulas with two alternate states

Mon, 24 Feb 2014 12:41:15 GMT

Thank you so much. Worked perfectly.