topic Variables between alternate states in QlikView

Variables between alternate states

nancy_sbeity — Thu, 16 Jul 2015 07:04:31 GMT

Hello,

I need a help.

In an inherited Alternate state:

I have "Projects" List box.
A button with set variable action that puts the value of the selected project in a variable vProject.

In alternate state AS1:

A list box that has to display all the tasks related to the selected project (The value of the variable).

I tried lots of expressions such as :

=if([Project Name]=$(vProject),[Task Name],'-')
=only({$<[Project Name]=$(vProject),>}[Task Name])

And I am not getting the answer. Any suggestions?

Re: Variables between alternate states

tresB — Thu, 16 Jul 2015 07:14:50 GMT

May be like:

=Aggr(only({$<[Project Name]=$::[Project Name]>}[Task Name]), [Task Name] )

Re: Variables between alternate states

nancy_sbeity — Thu, 16 Jul 2015 07:39:31 GMT

Thank youu,

It works.

Re: Variables between alternate states

tresB — Thu, 16 Jul 2015 07:46:14 GMT

If you close this thread by marking the reply 'Correct' , other people searching for similar problem resolution would find it easily and be helped. Not only that, your marking would put some points in my bag - a deserved appreciation from you.