Creating A Bar Chart - Trouble w/ data structure

Mon, 26 Jan 2026 18:19:17 GMT

I am trying to make a candle stick chart of sorts with high and low daily prices. The problem is writing the expression equation. There are three columns of of interest in the table: Date; TYP; PX. Whenever TYP column is 7 the price for that day is the high price. Whenever TYP is 8 the price for that day is the low price. I am using the date as the dimension. There are no missing values so for the top of the chart I was using:

if(if(TYP=7,PX,0) > if(TYP=8,PX,0),if(TYP=7,PX,0),if(TYP=8,PX,0))

and for the bottom

if(if(TYP=7,PX,0) < if(TYP=8,PX,0),if(TYP=7,PX,0),if(TYP=8,PX,0))

but this seems very inefficient and is not producing any output.

Any way to simply or make this work? Much appreciated.

topic Creating A Bar Chart - Trouble w/ data structure in QlikView

Creating A Bar Chart - Trouble w/ data structure