topic Re: How to divide expression with dimension (month) in QlikView

How to divide expression with dimension (month)

Sat, 21 Sep 2013 23:03:33 GMT

I have a Straight Table chart with three kinds of information: product group (10 categories), gross margin (an expression), and month. I want each product group to be a row, each month to be a column, and then the gross margin for that particular group and month in the cells.

How can I do this? From what I can tell, I can only use product group in the dimensions tab, since putting month in the dimensions tab as well ends up creating a row for each possible product group/month combination. It seems I'll need to involve month in the gross margin expression. Do I need a gross margin expression for each month? Is there a way I can use a variable or function to automatically generate the expression for each month?

Thanks for the help

Re: How to divide expression with dimension (month)

qlikpahadi07 — Sun, 22 Sep 2013 11:46:19 GMT

Instead of Straight Table use Pivot Table Dimension as Product Group and Month ... then click and Select Month dimension you will see a Vertical Blue Arrow Highlighted then drag it to right top you will find a arrow changed to horizontal and leave it.

may be this help you

Re: How to divide expression with dimension (month)

ariel_klien — Sun, 22 Sep 2013 12:03:40 GMT

Hi,

You can do a pivot table (in the create chart) and put the month in columns.

Please see the attachment.

i hope this will help you.

Ariel

Re: How to divide expression with dimension (month)

Sun, 22 Sep 2013 19:01:14 GMT

Hey Mate,

Change chart object to Pivot and add month as dimension. Drag month dimension to top right corner of where the month dimension is currently. You will see just before you drop the dimension that there is an arrow indicating where the dimension will be populated. If the arrow is pointing to to the right, you good to go

There are a few differences between straight and pivot tables (i.e subtotals / show partial sums) and it really depends on the design approach and how creative you want to be visually (i.e. show Design Grid > {enables - format cells}). Pivot is quicker to create, but creating an expression for each month is not that time consuming

Let me know if you come right

Cheers,

Byron

Re: How to divide expression with dimension (month)

Mon, 23 Sep 2013 08:49:51 GMT

Hi,

I need to create one straight table or pivot table. I need to get Sum(Amount) where ActualID=AccountID. for each individual employee. The dimension is EmployeeID. But this EmployeeID and Amount are from one table, whereas ActualID is from another table.

Could you help me how to write the expression please as it is urgent for me please

Thanks.