topic Re: chart manipulation in QlikView

chart manipulation

Fri, 29 Jun 2012 05:38:58 GMT

I have a table, having events with different date but same name, i want to calculate event with highest cost, i need to show events having highest investment in a chart

EventId	EventName	Date	Cost
event1	ABC event	1.1.2011	1000
event2	ABC event	15.2.2011	3000
event3	XYZ event	27.3.2011	2000

Re: chart manipulation

giakoum — Fri, 29 Jun 2012 05:43:58 GMT

Hi.

this sounds easy so maybe I am missing something here.

Create a bar chart, sorted by cost desc and there you go. You can combine eventid and eventname as a dimension so that you have a unique reference.

BR, Ioannis

Re: chart manipulation

Fri, 29 Jun 2012 05:54:45 GMT

yeah it should be a simple one, but its not working rite, its a bar chart, i can have event id as dimension and cost as expression, but the problem is that i have to show the event name on dimension

i have taken bar chart, event name as dimension and cost as expression, it is summing the cost up for the event name which is not the true picture

Re: chart manipulation

giakoum — Fri, 29 Jun 2012 06:06:11 GMT

You can combine eventid and eventname as a dimension so that you have a unique reference :

eventid & ' ' & eventname

Re: chart manipulation

Fri, 29 Jun 2012 06:10:48 GMT

Try this,

Dimension : EventName

Expression : =aggr(max(Cost),EventName)

Re: chart manipulation

Fri, 29 Jun 2012 06:14:54 GMT

yeah thats giving the right statistics, but the user is not interested in the eventids, how to hide the eventid from the dimension

Re: chart manipulation

Fri, 29 Jun 2012 06:30:30 GMT

Then, dont take Eventid in the dimension . What is the final fomat expected here..?

Re: chart manipulation

Fri, 29 Jun 2012 06:36:35 GMT

Thanks yogan, ur answer solved the problem