Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data:
And I used alternate states to calculate, for example, when a vip bought ITEM=B, what other ITEM did they buy in the same TRANS?
I created a alternate state named Items 123, and I choose B then, copy B to alternate state and clear the inherited state,like:
then I created a straight table, expression is sum(QTY), and dimension is
=Aggr(
If(
Count(DISTINCT {<ITEM = [Items 123]::ITEM>} ITEM)>0
and
Count(DISTINCT {<ITEM = -[Items 123]::ITEM>} ITEM)>0
, ITEM
)
,TRANS
)
but the result is null.
I don't know how to solve it and you can find all what I showed you in the attached file.
In this example, what I want is :
ITEM QTY
A 2
C 1
I hope I have clarified what I want. If you have any problem pls feel free to tell me.
Thank you so much!
Hi
to use alternate state you need to declare 2 groups
Then duplicates every filter (one inherites from group1 and other from group2) you need to compare
Then pick up a selection in filter-G1 and filter-G2 to make comparaison
Best regards
Chris
Hi christian,
Thank you for your reply. I have created a alternate states called Items 123,so now I have two groups right?
inherited and Items 123. And I have a button to copy the selections from inherited to Items 123. so I think I can use this
to compare. Is what I said right?
No you need to create 2 groups (items123 and items456)
then you must need filters related to both of this groups
Ex :
List box with field_1 status items123
List box with field_1 status items456
then you select in one or both of your list box
Expressions have to be made like sum({<items123>} values)
chris
Could you please give me a example if possible?
Because I tried to create a state Items 456, and two list boxes, and choose one of them, it didn't work.
Here is the way to do it
click alternatestate
Add 2 groups (Group1, group2, or whatever Items123...)
Add new list object and
Add a second object and affect Group2
in your Graph object , expressions
sum({[Groupe1]} Montant)
sum({[Groupe2]} Montant)
best regards
Chris
Hi chris,
I know how to create a alternate state and how to use it, but I don't know how to calculate what I want:
for example, when a vip bought ITEM=B, what other ITEM did they buy in the same TRANS?
Do you have any idea about that?
Sorry I misunderstood your problem
you could solve this by the model, creating a second table VIP / ITEM as ITEM2 / Quantity as QTY2
Select ITEM From Table 1 will link to VIP (table1 and Table 2) and gives all items bought by VIP in table 2
but i'm not sure this will fit all your needs because i don't know what exactly you have to do
Best regards
chris