How To Filter For Dimension

[haberinyok]

Hello everyone, this is my first question.

apologize in advance of all my inexperience...

-i m trying to make a report. 

- there is a qvd for loading the values. for example  for month of may :

1001  = $3

1002 = $5 

- and we are making the group with these ID's in excell (1001 and 1002 = personal consumption etc.) 

-after than we have another table(checkbox) and this table including things for example : Joey, James, Desk, Table

the question is : 

when i'm choose Joey i want to see in Personal Consumption group with 1001, 1002 ID's

if i choose Desk, i dont want to see Personal Consumption group and 1001, 1002 ID's of course... 

What should i do?

[Taoufiq_Zarra]

can you share a sample data and the expected output ?

[haberinyok]

for example : if i check "FİLO" button i just want to see "7030000"'s row. and values for its.

edit: screenshot deleted.

[Taoufiq_Zarra]

what is the relation between the two Field Mali Kalem and Filo ?
Normally I see set analysis, but I didn't understand the relation

[haberinyok]

there is no relation for now. 

i'll make relation for them this is why i want your help. 

for example im gonna say : 

If I choose "FILO" show me 7001, 7002, 7003 "mali kalem"s.

so when i choose FILO i dont want to see 7004 or the others. 

i'll write which i want mali kalem's in code row.

[Taoufiq_Zarra]

@haberinyok  I'm not sure I understand correctly, but I'm going to try this 🙂 :

suppose that the field contains FILO is called A

and the measure is C

The expression :

=if(GetFieldSelections(A)='FILO',sum({<[Mali Kalem]={'7001','7002','7003'}>} C))

will return the measure sum(C) for Mali Kalem 7001..7003 if you select FILO in A

[haberinyok]

hehe, i am sorry. this is my bad i guess...

 im gonna try one more time : 

can i write the code in the "Dimensions" tab/area? 

my code in expression area works well.

i just want to make filter by the "FILO" area.

[Taoufiq_Zarra]

Sorry, I didn't get it .

can i write the code in the "Dimensions" tab/area? YES

in dimension for example if(A='FILO',.....)

[haberinyok]

any other idea?

something like that if(A)="FILO", ShowMe([Mali Kalem]='7003') 

1-Choose = FILO

2-Then see on the right table : HIZMETLER > MLZ-TAKAS > 7003 > 0,0X

then hide the other rows (7001, 7002 etc.)

[Brett_Bleess]

To Taoufiq's original suggestion, really need the QVW in order to see the data model and full chart properties to be able to come up with any good suggestions.  If you have sensitive data, you can use the Settings\Document Properties\Scrambling tab to scramble any fields that have sensitive data prior to posting.  Not sure you are going to get further help unless you can do that.

Regards,
Brett