topic Re: excluding/ignoring fields in set analysis in QlikView

excluding/ignoring fields in set analysis

Anonymous — Tue, 28 Jan 2014 13:21:14 GMT

Hi All,

I have a set-analysis that sums material quantity for the last month of the selected period. this set should not calculate two of the fields (GsPeelings,GnPeelings).

i use this Set-Analysis to do so:

Sum({$<[Month Num]={$(=Max(Month))},GsPeelings={0}>+<GnPeelings={0}> }ACT_SubQnty)

It works well when I select one month but when I select more then one month period the result is wrong.

my guess is that the syntax ">+<" is the problem

would appreciate any help

thanks

Avner

Re: excluding/ignoring fields in set analysis

MK_QSL — Tue, 28 Jan 2014 13:22:38 GMT

Sum({$<[Month Num]={'$(=Max(Month))'},GsPeelings=,GnPeelings=> }ACT_SubQnty)

Re: excluding/ignoring fields in set analysis

Anonymous — Tue, 28 Jan 2014 13:27:20 GMT

Hi Manish,

thanks for the quick reply, but it didn't work.

it brought a different wrong result

Re: excluding/ignoring fields in set analysis

MK_QSL — Tue, 28 Jan 2014 13:31:05 GMT

If you select more than one month, the result will be only for max month of the selection.

In case if you want result for all month... remove month field from Set Analysis...

Sum({$<GsPeelings=,GnPeelings=> }ACT_SubQnty)

Re: excluding/ignoring fields in set analysis

Anonymous — Tue, 28 Jan 2014 13:38:26 GMT

that's true,

but i wish to present sum of selected months on one column, and on the other, present only last month's total.

sorry my explanation wasn't clear enought

Re: excluding/ignoring fields in set analysis

MK_QSL — Tue, 28 Jan 2014 14:25:31 GMT

This will give you Max Month's SUM

Sum({$<[Month Num]={'$(=Max(Month))'},GsPeelings=,GnPeelings=> }ACT_SubQnty)

This will give you SUM for all selected months...

Sum({$<GsPeelings=,GnPeelings=> }ACT_SubQnty)

If still not correct, request you to upload your apps.

Re: excluding/ignoring fields in set analysis

Anonymous — Wed, 29 Jan 2014 14:10:15 GMT

Hi manish,

thanks for your help, there's still problem with the calculation, uploading my model is a bit of a problem.

I'll check if i can sort it out

thanks again

Re: excluding/ignoring fields in set analysis

MK_QSL — Wed, 29 Jan 2014 14:26:55 GMT

It's difficult to answer without looking upon your apps.

You may reduce data and attach sample file.

Re: excluding/ignoring fields in set analysis

Anonymous — Thu, 30 Jan 2014 11:00:33 GMT

Hi manish,

I used a flag to point out the peel section, so i don't have to create complex set

Sum({$<[Month Num]={'$(=Max(Month))'},Peel_Flag={0}> }ACT_SubQnty)

thanks again