Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
christian77
Partner
Partner

ALTERNATE STATES

Does anybody know how to set an alternate state?

Thanks.

1 Solution

Accepted Solutions
Not applicable

The hirarhy of the states:

Capture.JPG

And then you can assign objects to the state you creaate:

Capture.JPG

View solution in original post

7 Replies
Not applicable

Hi ,

I'll try to explain the concept and the thechnical side of it,

Let's say we want to analyse the conection between two products we sale,

and we want to analyse it dinamcly between any products wh own,

In QV it's now realy easy to make a kind of duplicate the set of the data we have,

Actually we know that if we choose one product from a ListBox  we will see the information abuot the product we chose,now we can declar thet we want same selections on another ListBox with the same Dimmension- product- refer to anoter side of the data we have (duplicate set the data) ,

Thechnicaly, you can create a set of data by settings->document properties->Alternate States.

We know that the $ sign mean that we want consider all the selection of our data- the dafult,

And the the expriesion is :

Function({$}field_name) ->sum({$}Sales)

Now after we declar  anoter state, lets say we called it Group1, we can use in Set Analysis :

Function({[State Identifier]}field_name) ->sum({[Group 1]} Sales)

Its important to understand that itlike s behave another set of data (theoreticly).

I attach an example.

I hope it will help you.

Yigal.

christian77
Partner
Partner

Great! That's what I wanted, settings->document properties->Alternate States, the way to do it.

Now let me show you my view.

Where is the tab Alternate States?

May it be the version?      11.00 11271.0 SR1 64-bit Edition (x64)

I still need a little more help. Thanks a lot.

alternatestates.jpg

Not applicable

Capture.JPG

Not applicable

The hirarhy of the states:

Capture.JPG

And then you can assign objects to the state you creaate:

Capture.JPG

View solution in original post

christian77
Partner
Partner

Thank you, thank you, and thank you.

I was lucky it wasn't a crocodile. It could have bitten me.

Not applicable

I'm glad i could help.

christian77
Partner
Partner

I appreciate also the Venn Diagram. Awsome!