topic Re: DEMAND/SUPPLY CURVE ON QLIK SENSE in Visualization and Usability

DEMAND/SUPPLY CURVE ON QLIK SENSE

alex90qlik — Fri, 23 Feb 2018 16:34:20 GMT

Hi,

I need to represent a demand/supply curve on qlik sense using a linear chart or another one.

I have a fact table with : quantity, price, date , hour and purpose (buy or sell).

I have to obtain a chart like this:

Can Someone help me?

Thanks

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

Digvijay_Singh — Fri, 23 Feb 2018 16:42:47 GMT

Try scatter chart as it has two measures, the more dimension data you have, closer the dots you will get but not sure if it exactly will look like the image you shared.

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

alex90qlik — Fri, 23 Feb 2018 16:53:05 GMT

i need 2 mesures:

1- rangesum(above(sum(quantity)) with purpose=buy

2-rangesum(below(sum(quantity)) with purpose=sell

on y-axis i want price.

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

Digvijay_Singh — Fri, 23 Feb 2018 17:12:04 GMT

Can you share sample data and expected output, as I said you can have one measure at X axis and another one at Y axis to compare measure's dots for different dimension values.

It appears somehow you would need to combine your listed Quantity measures, but cannot say further without seeing the sample data and expected output.

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

alex90qlik — Mon, 26 Feb 2018 13:37:03 GMT

here some rows:

DDATE_AGGR	HOUR_AGGR	QUANTITA_AGGR	PURPOSE_AGGR	PRICE_AGGR	ID_FAMIGLIA_ZONA
12-01-2018	1	0,001	Buy	0,01	96
12-01-2018	1	0,001	Buy	8,23	50
12-01-2018	1	0,001	Buy	23,72	50
12-01-2018	1	0,001	Buy	27,95	50

i want to obtain a char like this :

thanks