Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marksmunich
Contributor II

Alternate State Set analysis expression in the front end

Hi Qlik's,

I have some set analysis expressions in the front end which uses the alternate states. Is it good idea to move this set expressions to the data model and then store as a dimension and then used the dimension along with the alternate states.

Any inputs.

thanks

M

1 Solution

Accepted Solutions
MVP
MVP

Re: Alternate State Set analysis expression in the front end

If you need complex set expressions in your front-end, it is usually worthwhile to add flag or indicator fields during load to simplify the expressions. So the answer to your question is that it is probably worthwhile adding some derived fields to simplify your set expressions and or alternate state selections.

Of course you cannot implement the set expressions directly in script, nor can you implement alternate states in the script - these concepts exist only in the front end.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies

Re: Alternate State Set analysis expression in the front end

I generally do as much in the script as possible to get a good data model.  Thus making the front end as simple as possible.

MVP
MVP

Re: Alternate State Set analysis expression in the front end

If you need complex set expressions in your front-end, it is usually worthwhile to add flag or indicator fields during load to simplify the expressions. So the answer to your question is that it is probably worthwhile adding some derived fields to simplify your set expressions and or alternate state selections.

Of course you cannot implement the set expressions directly in script, nor can you implement alternate states in the script - these concepts exist only in the front end.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
marksmunich
Contributor II

Re: Alternate State Set analysis expression in the front end

I have choosen to go with flags in the scripting part.

Community Browser