topic alternate state in QlikView

alternate state

Anonymous — Wed, 21 Nov 2012 09:16:37 GMT

Hi,

I've two listbox for the same field , SALES_YEAR, with different state:

SALES_YEAR associated to state 1

SALES_YEAR normal list box without state declaration

Than, I've a pivot that should change on selection made by the SALES_YEAR state 1, but the pivot always take in consideration the selections made by

the other list box SALES_YEAR without state. The pivot has state 1. Into my expressions, I'm using sum( <set analisys.... =only(getfieldselections(SALES_YEAR)....

MAy I specify into the expression the state also , like .....=only(getfieldselections(STATE.SALES_YEAR) ?

In my mind I was convinced that all the controls with a different state should be disconnected from the rest (without state), but it seems not true, or

for sure, I'm making some mistake. Does anyone put me on the right track ?

Thanks in advance

Re: alternate state

swuehl — Wed, 21 Nov 2012 09:55:48 GMT

How does your expression exactely looks like?

I assume you are implicetly or explicetly referring to default state in your set analysis expression.

Re: alternate state

Anonymous — Wed, 21 Nov 2012 10:14:27 GMT

Hi,

here my expression.

Sum({<YEAR_DB={$(=only(SALESYEAR-1))}, MONTH_DB={"<=$(=only(SALESMONTH))"}>} Salesvalue)

I want to sum all the salesamount based on the selectedyear(SALESYEAR) and selected month(SALESMONTH)

In this case I'0m trying to retrieve 2011 values.

Re: alternate state

swuehl — Wed, 21 Nov 2012 10:19:51 GMT

Could you upload a small sample qvw, please?

Re: alternate state

Anonymous — Wed, 21 Nov 2012 11:16:08 GMT

It's bit hard, because it's a part of not so small application. What can I do to send you some info ?

Re: alternate state

swuehl — Fri, 23 Nov 2012 11:21:05 GMT

It would be best if you could create a small sample app with few data, that demonstrates your issue, but still being close to your data model (that could be the tricky part).

I was not able to reproduce the issue here, so I assume my setting is somewhat different.