topic set analysis problem in QlikView

set analysis problem

Wed, 19 Mar 2014 06:28:39 GMT

I m having this expression in my chart column for last year sales

Num((SUM({<year = {'$(=Max(year)-1)'}>}saleQty)),'#,##0')

now i want to add another sale from excel sheet. excel sheet is having these columns

i want to add this saleQty to above expression. how can i do this

jagan — Wed, 19 Mar 2014 06:42:29 GMT

HI,

Concatenate this data to your existing table like this

Concatenate(ExistingTableName

LOAD

FROM Datasource;

Now use the same expression.

Regards,

Jagan.

kumarnatarajan — Wed, 19 Mar 2014 06:44:20 GMT

HI Dushan,

I think your set analysis is right.

EX:

Num((SUM({$<year = {"$(=Max(year)-1)"}>}saleQty)),'#,##0')

First check your year field format. Then also check

=Max(year)-1 in text box what it has been return then you will get good ideas.

Wed, 19 Mar 2014 06:52:35 GMT

Hi,

As per your post you want to add another sales column against the dimension as you are using now in the chart.

This is your current expression for salesQty

Num((SUM({<year = {'$(=Max(year)-1)'}>}saleQty)),'#,##0')

If you want to calculate the sales on another column like SalesVal

Num((SUM({<year = {'$(=Max(year)-1)'}>}SalesVal)),'#,##0')

Now you will get total sales by adding these 2 expressions.Now your final expression would be like

Num((SUM({<year = {'$(=Max(year)-1)'}>}saleQty)),'#,##0') + Num((SUM({<year = {'$(=Max(year)-1)'}>}SalesVal)),'#,##0')

If this is not you are looking for then eloberate your requirement in detailed.

Regards

Kumar

Wed, 19 Mar 2014 07:25:19 GMT

thanks all