topic Re: Dynamic field generation in QlikView

Dynamic field generation

fatihsahin — Mon, 06 Jul 2015 06:39:04 GMT

Hi,

I need to create a dynamic structure for one of my QlikView applications:

Lets say I have following data:

ProductionDate V1(Jul) V2(Aug) V3(Sep) V4(Oct) V5 (Nov) V6 (and so on) V7 V8 V9 V10 V11 V12

July 2015 10 0 0 0 0 50 0 0 30 20 15 100

So every V1 is representing July and I have a corresponding value for every "V" value but based on that ProductionDate this V1 to V12 distribution should be dynamic. In example above V1 represents July V2 August and so on.

But lets say I have production date Oct 2015 than I want to have this:

ProductionDate V1(Oct) V2 (Nov) V3 (Dec) V4(Jan) V5 V6 V7 V8 V9 V10 V11 V12

Oct 2015 10 0 0 0 0 50 0 0 30 20 15 100

So basically the V1 to V12 distribution should be calculated dynamically based on the "ProductionDate"

Any idea how I can achieve that?

Regards

Re: Dynamic field generation

jagan — Mon, 06 Jul 2015 06:55:57 GMT

Hi,

Try transforming with CrossTable(), if you attach some sample file then it is easier to provide the solution.

Regards,

jagan.

Re: Dynamic field generation

Kushal_Chawda — Mon, 06 Jul 2015 07:09:38 GMT

Please see the attached.

This is what you are looking for?

Re: Dynamic field generation

fatihsahin — Mon, 06 Jul 2015 07:33:51 GMT

Hi Kush,

thanks a lot for your example. Definetely going to the right direction but the fields V1 to V12 are 12 different fields which are containing different values but the only date we have is the productiondate.

So if the production date is for example

March 2015 the table should start with the V3 and go on like this:V4,V5,V6,......V12,V01,V02

if we have

May 2015: Starting with V5.....V12,V01,V02,V03,V04,V05

Regards

Fatih

Re: Dynamic field generation

Kushal_Chawda — Mon, 06 Jul 2015 07:46:11 GMT

if you can share sample data it will be helpful

Re: Dynamic field generation

Kushal_Chawda — Mon, 06 Jul 2015 07:54:34 GMT

If V1 to V12 are different fields then we can use cross table to bring it as values (single field)