Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Totals with Set Analysis, bug or am I stupid?

Hi all,

I've got this expression to work out Total Market Share, trying to get it to work with a total for each month in a line chart.

My expression:

sum(Value)/

          sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total(<[Chart Periods]>Value))

The weird thing is at the top of the expression editor it says: "Expression OK" but in the actual expression there is a red squiggly line under the last bracket (see above)

Is my syntax wrong?

Any help would be appreciated.

Tx, Cindy

1 Solution

Accepted Solutions

Re: Totals with Set Analysis, bug or am I stupid?

There shouldn't be parentheses around the <[Chart Period]> part:

sum(Value)/

          sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total <[Chart Periods]>Value)


talk is cheap, supply exceeds demand
2 Replies

Re: Totals with Set Analysis, bug or am I stupid?

There shouldn't be parentheses around the <[Chart Period]> part:

sum(Value)/

          sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total <[Chart Periods]>Value)


talk is cheap, supply exceeds demand
Not applicable

Re: Totals with Set Analysis, bug or am I stupid?

Thank you, embarrassingly easy. Just weird how the Expression was "OK".

Community Browser