Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate State Connections

Dear All,

I want to see comparison of Sales for two different periods.

I have selections boxes:

Country (Alternate state: A);

City (Alternate state: A);

YearMonth (Alternate state: A)

YearMonth (Alternate state: B)

I have a table where Dimensions are "Country" and "City" - alternate state A.

1st expression is Sales1 with YearMonth from alternate state A

2nd expressions is Sales2 with YearMonth from alternate state B

I can see two different values for each Sales if the YearMonth is selected. Good!

I have selected one City from list box (alternate state A) to see Sales just for this City, but still displays all Cities with Sales even there was no Sales in Sales1 or Sales2. The problem is that I have to choose the same City but in alternate sate B to see just that one specific City.

Is there any way that I can use "City" (alternate state A) in expression with "Sales" and "YearMonth" in alternate state B?

Thanks,

1 Reply
Not applicable
Author

Hi David, I get the reference to the selection of City in State A using this formula:  SUM( {B } Sales2) This formula set's the state for the sum formula to B and changes the selected City to them from state A. Hope this helps Helmut