Adding numbers manually

[#1]

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

[arvind_patil]

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

[#3]

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

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

[Anonymous]

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];

[#5]

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

[#6]

Anyone? :S

[sasiparupudi1]

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]

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