topic Re: Expression with Different Alternate States doesn't work in QlikView

Expression with Different Alternate States doesn't work

dafnis14 — Tue, 04 Nov 2014 09:32:50 GMT

Hi,

The following expression references different alternate states.

But it doesn't work, i.e., it doesn't take into account the actual selections.

sum ({<Date=State2::Date,Country=Country1::Country,Branch=Branch1::Branch>}Quantity)

Can someone help?

Thanks!

Re: Expression with Different Alternate States doesn't work

Gysbert_Wassenaar — Tue, 04 Nov 2014 09:50:12 GMT

The syntax is correct. Can you post a document that demonstrates the problem?

Re: Expression with Different Alternate States doesn't work

CELAMBARASAN — Tue, 04 Nov 2014 09:53:20 GMT

You meant that it doesn't considers the default state selections?

Re: Expression with Different Alternate States doesn't work

dafnis14 — Tue, 04 Nov 2014 10:23:10 GMT

Right. It ignores the selections.

I have defined a state for the sheet, and left only 2 states for listboxes.

Using this expression takes into account selection in a branch, as expected, but not the date:

sum({<Date=State1::Date,Country=$::Country,Branch=$::Branch>}Quantity)

It seems there is an issue with such a syntax:

State2::Date

Thanks!

Re: Expression with Different Alternate States doesn't work

dafnis14 — Tue, 04 Nov 2014 11:51:12 GMT

Hi,

The original document is huge.

But I think there is a clue which might help:

The list box with the defined state has a Branch Description field to select .

But the expression is including the field Branch, which is the linked code to the Branch Description.

Before alternate states, the set analysis expression worked fine:

sum ({<Date=p(Date1), Country=p(Country1),Branch=p(Branch1)>}Quantity)

Do you have an idea how this can be implemented with alternate states?

Thanks!

Re: Expression with Different Alternate States doesn't work

Gysbert_Wassenaar — Tue, 04 Nov 2014 12:21:32 GMT

sum ({<Date=p(Date1), Country=p(Country1),Branch=p(Branch1)>}Quantity)

If this works then Date1, Country1 and Branch1 are not alternate states but fields. Or have you defined alternate states with those names as well?

Re: Expression with Different Alternate States doesn't work

sakamsureshbabu — Tue, 04 Nov 2014 12:25:18 GMT

my dimension is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show

Re: Expression with Different Alternate States doesn't work

dafnis14 — Tue, 04 Nov 2014 12:32:46 GMT

Hi,

I have managed to resolve my issue.

1. I have defined a state for the document.

2. For relevant list boxes I have defined states.

The expression that works as expected is the following:

sum({State1<Date=$::Date,Country=p(Country),Branch=p(Branch)>}Quantity)