topic Re: Price Point issue in QlikView

Price Point issue

Wed, 25 Nov 2020 16:16:04 GMT

I have a column name AvgPrice

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

Pls help

sunny_talwar — Thu, 04 Aug 2016 11:04:17 GMT

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

Thu, 04 Aug 2016 11:23:58 GMT

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 — Thu, 04 Aug 2016 11:49:01 GMT

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

varshavig12 — Thu, 04 Aug 2016 11:56:31 GMT

Something like Trellis ?

Not sure.

Anonymous — Thu, 04 Aug 2016 12:01:36 GMT

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

vinieme12 — Thu, 04 Aug 2016 13:39:38 GMT

See Attached