topic more than one expression in single chart in QlikView

more than one expression in single chart

Fri, 24 Dec 2010 12:09:39 GMT

Dear All,

I want to know whether i can put 4 or 5 Expressions in one Charts.

Ex: Dimension as (Cyclical) : Day,Week,Qtr,Month,Year

Expressions as : BunkerPrice,Income,Cost,Profit

Please Suggest me.

With Regards,

Pranav

more than one expression in single chart

sparur — Fri, 24 Dec 2010 12:13:45 GMT

Hello, Pranav.

Can you explain me why you can add new expression in your chart?

more than one expression in single chart

tresB — Fri, 24 Dec 2010 12:19:24 GMT

Hi Pranav,

If you are really new to QV, then staright answer is "YES". you have to click on "Add" button to add expressions in "Edit Expression" tab. Or, might be you have something else difficulty. if it is so, explain a bit more.

regards,

tresesco

more than one expression in single chart

Fri, 24 Dec 2010 12:19:40 GMT

sure you can, why not?

more than one expression in single chart

Fri, 24 Dec 2010 13:08:01 GMT

Dear All,

Sorry my mistake , was not able to explain the Questioncan

Actually can i have all this Expressions like

1. Bunker Price have 2 Expression a) Contract and b) MTM,

2.Income a)Contract b) MTM

3. Cost a) Contract b) MTM

4. Profit a) Contract b) MTM

So i want to Dimension with 1 Expression Bunker Price , then Chart Should Show me Bunker Price Contract and Bunker Price MTM Expression only,

When i want to see Dimension with Income then i can See Income Contract and Income MTM Only.

Can it be Possible.

May this will be Helpful Requirements to get an Answer.

Again Thanks For quick Reply, Mamy Many Thanks.

Waiting for Reply.

Regards,

Pranav

more than one expression in single chart

Fri, 24 Dec 2010 13:40:19 GMT

you can make your expressions conditional on Dimension, so i think yes you can!

If your dimension is a cyclic group you can use GETCURRENTFIELD to make a expression work (visible)