topic Re: Set Analysis question: Only consider impact of certain fields in QlikView

Set Analysis question: Only consider impact of certain fields

alexis — Thu, 19 Dec 2013 10:17:06 GMT

At the moment I am getting the SUM of SALES for the ENTIRE dataset {1} subject to the value of a flag and some date ranges as seen below which works as expected..

= Sum({1<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

I have a multi-select box that displays 4 fields (lets call them Field1, ... Field4) - I want to extend the above syntax to consider these selections as well - any suggestions?

Thanks in advance

Alexis

Re: Set Analysis question: Only consider impact of certain fields

Anonymous — Thu, 19 Dec 2013 10:22:03 GMT

Use

Sum({$<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

$ will itself consider the selections of fields of multibox.

Re: Set Analysis question: Only consider impact of certain fields

Gysbert_Wassenaar — Thu, 19 Dec 2013 10:22:18 GMT

See this document: Ignore all selections except some specific fields using Set Analysis

Re: Set Analysis question: Only consider impact of certain fields

alexis — Thu, 19 Dec 2013 10:25:06 GMT

$ will consider ANY selection made - I only want to consider the impact of the 4 fields mentioned 🙂

Thanks for responding

Alexis

Re: Set Analysis question: Only consider impact of certain fields

alexis — Thu, 19 Dec 2013 11:12:53 GMT

Hi Gysbert

That is EXACTLY what I wanted

THANK YOU!

Alexis