How to connect fake data to sum(Sales)

Wed, 02 Mar 2016 09:30:12 GMT

Hello everyone,

I have a map in qlik sense where I'd like to connect test Postal codes (not from the customer) to sum(Sales). I've heard that you can do that, but I don't know how to. There's no option for me to use the customers real postal codes, hence trying to do it this way.

I heard you can use random function, but how? This is what my map looks like right now:

I would like to be able to be able to show sum(sales) per city. How do I go about this when the postal code is fake?

Sincerely,

Betty Habtemariam

Re: How to connect fake data to sum(Sales)

sunny_talwar — Wed, 02 Mar 2016 09:33:39 GMT

May be create sales in the script like this:

LOAD OtherFieldNames,

Ceil(Rand() * 100) * 100 as Sales

FROM Source;

and then you can use Sum(Sales)

topic How to connect fake data to sum(Sales) in App Development

How to connect fake data to sum(Sales)

Re: How to connect fake data to sum(Sales)