topic Re: Inputfield and $Syn in QlikView

Inputfield and $Syn

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Inputfield and $Syn

kaushiknsolanki — Fri, 30 Jun 2017 09:38:06 GMT

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

Re: Inputfield and $Syn

Anonymous — Fri, 30 Jun 2017 09:50:51 GMT

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