topic Re: How to use Cell Value of a report chart in set analysis expression in QlikView

How to use Cell Value of a report chart in set analysis expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I am having a Straight table report like

Year Month step Expression=sum(Sales), I want to use Step field set value in expression using set analysis like:

2016 5 step1 sum({<Field1={'step Field cell value'}>} Sale) //here cell value is: step1

2015 6 step0

2014 4 step1

Here step field value is changing at every record.....I do want to use any conditional expression...

Just want this step's cell value every time in expression.

Pls suggest.

Regards,

Balraj Ahlawat

Re: How to use Cell Value of a report chart in set analysis expression

tresB — Mon, 26 Sep 2016 11:01:47 GMT

Set analysis doesn't evaluate row-wise. So what you are trying is not easy without conditional statement or some complex synthetic dimension. However, it seems that what you want is somehow similar to Sum(Sales) i.e.- expression without the set itself. Can you explain your scenario better?

Re: How to use Cell Value of a report chart in set analysis expression

trdandamudi — Mon, 26 Sep 2016 11:04:42 GMT

I am not sure if I can understand your question... can you explain little bit... It looks like you don't need the expression because it is already getting what you need...

Re: How to use Cell Value of a report chart in set analysis expression

Anonymous — Mon, 26 Sep 2016 11:06:02 GMT

Hi,

Try this

Sum(Aggr(sum({<Field1={$(=Only(Step))}>} Sale),Step))

Regards!

Re: How to use Cell Value of a report chart in set analysis expression

Anil_Babu_Samineni — Mon, 26 Sep 2016 11:12:26 GMT

I don't think Row level can accept using Set expression, Can you please explain bit more on your requirement. So that, we can help you better way and we can open other logic too. Thanks