Price Point issue

[#1]

Hi

I have a column name AvgPrice

I want to differentiate  5, 7, 9,10,11 like this price point

Pls help

[sunny_talwar]

Not sure I understand what you are trying to do. Can you elaborate a little more?

[#3]

hi Below is the chart which is in Tableau.

Now I want same chart in qlikview.

Showing sales with different price points like $5,$7,$9,$11.88

this is the formula which I used in Tableau now.

if [Avgprice]>4.95 and [Avgprice]<5.05 then "$5"

elseif [Avgprice]>6.95 and [Avgprice]<7.05 then "$7"

elseif [Avgprice]>8.95 and [Avgprice]<9.05 then "$9"

elseif [Avgprice]>9.95 and [Avgprice]<10.05 then "$10"

elseif [Avgprice]>11.83 and [Avgprice]<11.93 then "$11.88"

elseif [Avgprice]>13.83 and [Avgprice]<13.93 then "$13.88"

elseif [Avgprice]>14.83 and [Avgprice]<14.93 then "$14.88"

else "Others"

END

I want same  in qlikview in bar chart .

[Anil_Babu_Samineni]

Did you try this, Before? If you have the data please share that. So that we can try to help, Please

[varshavig12]

Something like Trellis ?

Not sure.

[Anonymous]

seems to be  , this person needs REFRENCE LINES paralle to y-axis ?

[vinieme12]

See Attached