Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alex90qlik
New Contributor

DEMAND/SUPPLY CURVE ON QLIK SENSE

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:

curva_domanda_offerta.png

Can Someone help me?

Thanks

4 Replies
Digvijay_Singh
Honored Contributor III

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

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.

alex90qlik
New Contributor

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

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.

Digvijay_Singh
Honored Contributor III

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

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.

alex90qlik
New Contributor

Re: DEMAND/SUPPLY CURVE ON QLIK SENSE

  here some rows:

DDATE_AGGRHOUR_AGGRQUANTITA_AGGRPURPOSE_AGGRPRICE_AGGRID_FAMIGLIA_ZONA
12-01-201810,001Buy0,0196
12-01-201810,001Buy8,2350
12-01-201810,001Buy23,7250
12-01-201810,001Buy27,9550

i want to obtain a char like this :

sample.png

thanks