Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

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
Author

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

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

Anonymous
Not applicable
Author

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
Author

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
Author

Anyone? :S

sasiparupudi1
Master III
Master III

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
Specialist
Specialist

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