topic Alternate state issues in QlikView

Alternate state issues

vijetas42 — Tue, 18 Mar 2014 06:09:59 GMT

HI,

Can I use same filters once for different alternate state in my dashboard and how?

Re: Alternate state issues

senpradip007 — Tue, 18 Mar 2014 06:21:01 GMT

Hi.

You can use same filter in different alternative state.

Try like:

Avg({[Group1]} [Adj.Close])

Avg({[Group2]} [Adj.Close])

Re: Alternate state issues

Tue, 18 Mar 2014 07:22:42 GMT

Hi Vijeta,

Try this

Expr 1 :- sum({[Grp1] <City=$::City,State=$::State>} sales)

Expr 2 :- sum({[Grp2] <City=$::City,State=$::State>} sales)

fields city and state (for e.g) are your common filters. Their states should be default or inherited state.
city and state will remain common for above two expressions.

Hope this will help you.

-Lalit

Re: Alternate state issues

vijetas42 — Tue, 18 Mar 2014 09:47:08 GMT

all these working with expressions but,i want for dimensions

Re: Alternate state issues

ashwanin — Tue, 18 Mar 2014 10:20:47 GMT

For Expressions its ok, but i don't think that for One Dimension you can use it for more than one time.

Can you post a sample?