Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

box plot on an expression not a single value

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

Jo

7 Replies
avinashelite

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

josephinetedesc
Creator III
Creator III
Author

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

avinashelite

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

daveamz
Partner - Creator III
Partner - Creator III

Hi Josephine,

Check Henric's post: Recipe for a Box Plot

Regards,

David

josephinetedesc
Creator III
Creator III
Author

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

josephinetedesc
Creator III
Creator III
Author

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.

josephinetedesc
Creator III
Creator III
Author

Hi Webmaster

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

Jo