Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using INPUTFIELD and aggregating by fields

Hi everyone,

I am working on building a star table model. my fact table contains sessions informations. as dimension tables I have a table named store, another one with time and another one with products. I want to add using INPUTFIELD a field with a value for each Month and Store.
This field will be used in my calculation later.

Also, for a session, I don't have the store directly but I have only a serial number that is in my store table.

Any idea of the script to use to do so?

Many thanks !