topic Re: How To Filter For Dimension in QlikView

How To Filter For Dimension

haberinyok — Wed, 08 Jul 2020 14:35:35 GMT

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?

Re: How To Filter For Dimension

Taoufiq_Zarra — Wed, 08 Jul 2020 14:36:03 GMT

can you share a sample data and the expected output ?

Re: How To Filter For Dimension

haberinyok — Wed, 08 Jul 2020 18:04:42 GMT

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

edit: screenshot deleted.

Re: How To Filter For Dimension

Taoufiq_Zarra — Wed, 08 Jul 2020 14:48:51 GMT

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

Re: How To Filter For Dimension

haberinyok — Wed, 08 Jul 2020 14:53:31 GMT

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.

Re: How To Filter For Dimension

Taoufiq_Zarra — Wed, 08 Jul 2020 18:19:11 GMT

@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

Re: How To Filter For Dimension

haberinyok — Wed, 08 Jul 2020 15:12:53 GMT

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.

Re: How To Filter For Dimension

Taoufiq_Zarra — Wed, 08 Jul 2020 15:20:43 GMT

Sorry, I didn't get it .

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

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

Re: How To Filter For Dimension

haberinyok — Wed, 08 Jul 2020 15:47:14 GMT

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.)

Re: How To Filter For Dimension

Brett_Bleess — Thu, 23 Jul 2020 11:21:12 GMT

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