Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using dimensions with expressions

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

5 Replies
robert_mika
Master III
Master III

Dimension as Staff

Create two expression

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

avg({<Year={2014}>}Cost)02-Apr-15 10-25-39 AM.jpg

Look here for tutorials:

Set Analysis: syntaxes, examples

malini_qlikview
Creator II
Creator II

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)

Not applicable
Author

hi simon.ijas

try this expressions by using set analysis

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

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

praveenak
Partner - Contributor II
Partner - Contributor II

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

Not applicable
Author

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

Thanks to everyone else too!

Cheers,

Simon