topic Re: box plot on an expression not a single value in QlikView

box plot on an expression not a single value

josephinetedesc — Tue, 08 Dec 2015 09:06:30 GMT

Hi I can do a boxplot graph when it involves a single value, For example:

name earnings

John 100

Paul 120

George 80

Ringo 90

However will i be able to do this for an expression?:

name net earning

John 100 - 10

Paul 120 - 12

George 80 - 8

Ringo 90 - 9

Re: box plot on an expression not a single value

avinashelite — Tue, 08 Dec 2015 09:11:28 GMT

you can calculate the net earning in the script and can use the same in the front end rite

Re: box plot on an expression not a single value

josephinetedesc — Tue, 08 Dec 2015 09:19:47 GMT

I have a problem calculating the expression in a script ... that would be best, but my data will not co-operate.

Re: box plot on an expression not a single value

avinashelite — Tue, 08 Dec 2015 09:26:27 GMT

Try like this:

Before the box plot expression try to add one more expression (this should be the first expression) , you can make it as invisible or hide and then for the box plot you can utilize the same expression name for the value

Re: box plot on an expression not a single value

daveamz — Tue, 08 Dec 2015 09:28:09 GMT

Hi Josephine,

Check Henric's post: Recipe for a Box Plot

Regards,

David

Re: box plot on an expression not a single value

josephinetedesc — Tue, 08 Dec 2015 10:02:28 GMT

Thanks David - I want to use an expression though ...

Re: box plot on an expression not a single value

josephinetedesc — Tue, 08 Dec 2015 10:23:20 GMT

I think I might be asking the wrong question ...

name/earning will not work cos it needs some other dimension (for example might need to clasify the names further into maybe musician/singer and then look at the classification as a box plot ...

load * inline [

name, rate, hrs, type

john, .1, 100, muso

paul, .2, 120, singer

george, .1, 90, muso

ringo, .2 80, singer

]

I used this:

LOAD * INLINE [

name, earning,type

john, 100, muso

paul, 20, singer

george, 900,muso

ringo, 800, singer

];

LOAD * INLINE [

aname, rate, hrs, atype

aJohn, .1, 1000, amuso

aPaul, .1, 200, asinger

aGeorge, .2, 1800, amuso

aRingo, .2, 1600, asinger

];

These both worked but the expression is:

min(Aggr(hrs*rate,,[atype]))

I had to change the expression the box plot wizard gave.

Re: box plot on an expression not a single value

josephinetedesc — Tue, 08 Dec 2015 12:01:46 GMT

Hi Webmaster

I madea mistake and put a helpful on the wrong comment and then I clicked assumed answered and i cannto go back!