topic Re: Re: Alternate state: Mixing current selection and alternate state selection in QlikView

Alternate state: Mixing current selection and alternate state selection

brijesh1991 — Thu, 19 Jun 2014 06:34:23 GMT

Hi,

I had an expression like this which is working on current selection.

Count(Distinct{$<TableFlag={Application},[Month (#)]={$(=Max(Month))},Year={$(=num(Max(Year)))},FiscalYear=,FiscalQuarter=>}Application_Number))

I wanted to do branchwise comoparisn over this expression.

I took two list boxes and created two alternate states- state1 and state2.

How to apply alternate state as well as current selection in above scenario?

Thanks,

BRIJESH

Re: Alternate state: Mixing current selection and alternate state selection

tresB — Thu, 19 Jun 2014 06:36:40 GMT

See: Is possible to use alternate States with set an... | Qlik Community

Re: Alternate state: Mixing current selection and alternate state selection

alexandros17 — Thu, 19 Jun 2014 06:37:18 GMT

An expression may work on a state or on current selection, obviously you may use 2 or more expressions in a chart.

if you need your expreession to work with alternate state write:

Count(Distinct{$ state1 <TableFlag={Application},[Month (#)]={$(=Max(Month))},Year={$(=num(Max(Year)))},FiscalYear=,FiscalQuarter=>}Application_Number))

let me know

Re: Alternate state: Mixing current selection and alternate state selection

brijesh1991 — Thu, 19 Jun 2014 07:30:40 GMT

Hi Tresesco,

I had two list box; BranchName A and BranchName B-both of which are same;just their alternate state is different.

I had a bar chart which have month as dimention and two expressions-one for BranchName A listbox and second for BranchName B listbox.

When I select one branch from BranchName A and one from BranchName B, then bar chart should show two bars- one for expression one and second from expression 2.

How to write these two expression.

Count(Distinct{$<TableFlag={Application},[Month (#)]={$(=Max(Month))},Year={$(=num(Max(Year)))},FiscalYear=,FiscalQuarter=>}Application_Number))

Re: Alternate state: Mixing current selection and alternate state selection

brijesh1991 — Thu, 19 Jun 2014 08:46:10 GMT

Hi Alexandros17

Thanks, but above expression doesn't work.

My requirement is like this:

I had two list box; BranchName A and BranchName B-both of which are same;just their alternate state is different.

I had a bar chart which have month as dimention and two expressions-one for BranchName A listbox and second for BranchName B listbox.

When I select one branch from BranchName A and one from BranchName B, then bar chart should show two bars- one for expression one and second from expression 2.

How to write these two expression.

Count(Distinct{$<TableFlag={Application},[Month (#)]={$(=Max(Month))},Year={$(=num(Max(Year)))},FiscalYear=,FiscalQuarter=>}Application_Number))

Re: Re: Alternate state: Mixing current selection and alternate state selection

alexandros17 — Thu, 19 Jun 2014 09:04:26 GMT

Here it is my example