topic Re: Dimension filter in QlikView

Dimension filter

Fri, 08 Jan 2016 05:39:41 GMT

Hi,

I only want to show the result of the table below if user select POStatus='200' from the DimensionTable. Please assist. I tried this if(GetSelectedCount(POStatus='200,OMSPO#) but failed. OMSPO# is the key. Thank you.

Re: Dimension filter

Fri, 08 Jan 2016 16:56:59 GMT

is there a link between POStatus and OMPSO#?

selecting a field to filter from will work if there is a relationship between the filtering field and the field to be filtered?

can you post the qvw?

Re: Dimension filter

Peter_Cammaert — Fri, 08 Jan 2016 17:06:02 GMT

GetSelectedCount() returns the number of selected values in a Field/Listbox, not the actual selected values.

You need GetFieldSelections(POStatus) = '200'.

If a user selects value 200, do you want to show the straight table, the total of the expression or something else entirely?

Re: Dimension filter

Fri, 08 Jan 2016 17:13:15 GMT

I agree with Peter that the syntax you are using is not correct, but how is the POStatus related to the OMSPO#? Is there a linked table? Is the POStatus field in a different table.If it was in the dame table as the other data, selecting the value from the lsit box would ahve filtered your data.

positing the qvw or data model would helo