topic Re: Using dimensions with expressions in QlikView

Using dimensions with expressions

Thu, 02 Apr 2015 05:58:43 GMT

Hi,

I have the following dimensions: Year (including 2013 and 2014), staff type and total (cost). I would like to create a combo chart that allows me to compare the average costs by staff type for both 2014 (bar) and 2013 (line). How do I write these expressions? I have tried but keep failing (my sql skills not so hot).

Also, can someone point me to where I can find how to write these expressions - that would be much appreciated

Regards,

Simon

Re: Using dimensions with expressions

robert_mika — Thu, 02 Apr 2015 09:26:31 GMT

Dimension as Staff

Create two expression

avg({<Year={2013}>}Cost)

avg({<Year={2014}>}Cost)

Look here for tutorials:

Set Analysis: syntaxes, examples

Re: Using dimensions with expressions

malini_qlikview — Thu, 02 Apr 2015 09:44:51 GMT

You can do the following:

1.Select chart -->Bar/Line chart or use a Fast Type change

2. Add Staff_Type and Year as Dimensions

3. write expression Avg(Cost)

Re: Using dimensions with expressions

Thu, 02 Apr 2015 12:53:25 GMT

hi simon.ijas

try this expressions by using set analysis

avg({<Year={2013}>}Cost)

avg({<Year={2014}>}Cost)

Re: Using dimensions with expressions

praveenak — Thu, 02 Apr 2015 13:25:07 GMT

Hi,

Use the expressions as below,

avg({<Year={2014}>}cost)------------make this as first expression to get 2014 as BAR

avg({<Year={2013}>}cost)------------make this as second expression to get 2013 as LINE

Re: Using dimensions with expressions

Thu, 02 Apr 2015 21:25:36 GMT

Thanks Robert - that is great. Thanks also for the guidance on the tutorials.

Thanks to everyone else too!

Cheers,

Simon