Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sindhu_ibizcs
Partner
Partner

How to Create Dummy records

Hi,

I have a Field called Material code which contains some data.

For Example:

Material Code:

1

2

3

4

5

I have to add 0 as a dummy value for each Records.How can I do this in the script.Could Anyone help me in this

Thanks

24 Replies
sunny_talwar

May be Concatenate?

Table:

LOAD [Material Code],

     OtherFields....

FROM ...

Concatenate (Table)

LOAD 0 as [Material Code]

AutoGenerate 1;

CarlosAMonroy
Creator III
Creator III

Hi Sindhu,

Go to the script -> Insert Menu -> Load Statement -> Load Inline

LOAD * INLINE [

    Material, Plant

    A, AA

    B, BB

    C, CC

    D, DD

];

Hope that helps,

Carlos M

sindhu_ibizcs
Partner
Partner
Author

Hi,

Thanks for your rly.

But this concept is not generate '0' value for each record. But I need '0' for each material code.Can u help me to find solution.

Capture.PNG

sindhu_ibizcs
Partner
Partner
Author

Hi,

Thanks.

But I have more no of material code..How can I do by use Inline Load.

Anil_Babu_Samineni

Can you elaborate more about your expected result?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sindhu_ibizcs
Partner
Partner
Author

When I select one material code,it'll show some value. if there is no value means it should display 'Zero'.

I used pivot table and not getting proper result in 'Show all values and Suppress Zero values'.

So I planned to create some dummy data for each material code.

Anil_Babu_Samineni

Like this?

Capture.PNG

Or

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sindhu_ibizcs
Partner
Partner
Author

Material Code ABC12 will have both Stock value as well as Zero value.  When there is no Stock value it should display Zero.This is what I want..

Anil_Babu_Samineni

I am sorry, If i misunderstand the Rek. Better if you provide sample data and expected result

From below, What are you expecting?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)