Inputfield and $Syn

[Anonymous]

Hi

I have this problem when using inputfields. I want to avoid having more than one $Syn, since it makes some of the other dimensions (Product, Class, Mediachannels) behave strangley. This happens when I use below script:

The reason that I need to have Product, Class, And MediaChannels_Name, is because I use the inputfield in a pivottable where those dimensions are included.

And if I don't include those dimensions, the input field will not work properly since the value entered in the input field would appear several places.

This happens to the Pivot table if I don't include all the dimensions. Then number entered in one cell, appears in all the cells where MediaChannels_Name is "Online".

So basically I want to know if there is solution to include all the dimensions without having more than 1 $Syn?

I hope that my explanation makes sense

Stefan

[kaushiknsolanki]

Hi,

You dont need to use the inline table to create a inputfield.

You can create a new field in your fact table or the transaction table and mark it as inputfield.

Like below.

Inputfield Belob;

Load *,'' as Belob

from trasaction;

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik

I'm not the main programmer of our QlikView solution, I'm just doing the minor adjustment and addition.

So can you please elaborate what you mean?

Stefan