Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Adding numbers manually

Hello,

I have been trying to google/Youtube/forum myself to understand how I add numbers manually in Qlik Sense.

For example we have a chart with sales updating daily, but we want to add different budgets that the sales representatives have. This can vary and thats why I want to be able to add them myself.

Is this possible? And if, How?

Fredrik

7 Replies
arvind_patil
Valued Contributor II

Re: Adding numbers manually

Hi Fedrik,

If you want to create field with random number then you can create same data as follows:

Load...

....

rand()*10 as myRandomField


From <Path>


Thanks,

Arvind Patil

Not applicable

Re: Adding numbers manually

Hmm, is it possible if you could be a bit more specific?

Do I add rand()*10 as myRandomField in an expression?

Re: Adding numbers manually

Maybe use an Inline Load

Here is sample pasted from the Online Help, https://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/...

LOAD * Inline

[CatID, Category

0,Regular

1,Occasional

2,Permanent];

Not applicable

Re: Adding numbers manually

Skärmavbild 2017-08-24 kl. 10.13.22.pngSkärmavbild 2017-08-24 kl. 10.13.27.png

Like this for an example, how do I correct the number to be similar to my expression? Above Im missing out on 156.

Not applicable

Re: Adding numbers manually

Anyone? Smiley Frustrated

sasiparupudi1
Honored Contributor III

Re: Adding numbers manually

May be use an excel file to store 2 column of data salesman and budget

Join this to your sales man table in the script

Hth

Sasi

tomasz_tru
Valued Contributor

Re: Adding numbers manually

You have to include data with representative and his budget in the data model.