how to add Dummy Dimesnion and Dummy values to that dimension in qlikview

[dunnalahk123]

Hi,

Can Some one help me how can we add Dummy Dimension and Dummy values to that Dummy Dimension in QLikview Script.

For Example :

i am adding a dummy Filed like below

Load

Qlikview as Dummy Field

From

XXX. QVD

Now to above Dummy Field i want to add values like Qlikview1, Qlikview2 .

How can we do that.

Best Regards,

Hk

[pradosh_thakur]

Load

'Qlikview'& rowno() as Dummy_Field

From

XXX. QVD

[parthesh]

Hello,

i think below code will work

LOAD     

     RowNo() as value

FROM

let me know in case of any issue

[dunnalahk123]

Hi,

Actually, i need as below

in Portfolio Dummy Field i need below values.

Global, DC, LES, IDS, TS

Best Regards,

[dunnalahk123]

Hi,

Actually, i need as below

in Portfolio Dummy Field i need below values.

Global, DC, LES, IDS, TS

Best Regards,

[parthesh]

Dime:

LOAD * INLINE [

    Dummy_DIM_COL

    Global

     DC

     LES

     IDS

    TS

];

is this fine?

[pradosh_thakur]

share the output please . if you want to add to any table and if there is any row wise condition to add the field to the column?

[pradosh_thakur · Accepted solution]

i would use this if it is random

Load

pick(mod(rowno(),5)+1,'Global', 'DC', 'LES', 'IDS', 'TS' )as Portfolio_Dummy_Field

From

XXX. QVD

[dunnalahk123]

Hi,

Thank You this as well Work for my Scenario .  🙂

Best Regards,

HK

[dunnalahk123]

Hi,

Thank You . it works.

Best Regards,

HK