topic Re: How to write a set expression in QlikView

How to write a set expression

Mon, 01 Jun 2015 08:02:56 GMT

Hi All,

Can any one help me on the below scenario, I have I fields like ''sales'', and Store open , ''Store number", "StoreKEY"" here Store Key has 1,2 numbers

Now I want the current period sales when Store Open>15 and exclude the Storenumbers those are having StoreKey 2 can any one guide me on the set analysis formula.

Regards

John

Re: How to write a set expression

kkkumar82 — Mon, 01 Jun 2015 08:21:22 GMT

Try this

Sum({<Storeopen = {">15 "}, Storenumbers -={2} > } Sales)

Re: How to write a set expression

tresB — Mon, 01 Jun 2015 08:27:35 GMT

Not sure if understood right. May be:

sum( {$<[Store number]= E({1<StoreKEY={2}>} [Store number]), [Store Open]={">15"}>} Sales )

Re: How to write a set expression

Mon, 01 Jun 2015 09:05:16 GMT

Thanks Kiran Ch, Tresesco.

Tresesco: can you please help me on this, if Store open field is not there I need to find it with some expression like

sum({<[Store number]={"=sum({<StoreKey = E({1<StoreKey={'2'}>})>}Sales)>21"}>}Slaes) is this expression correct ?

Re: How to write a set expression

tresB — Mon, 01 Jun 2015 09:21:27 GMT

Syntax looks okay. However, not knowing exactly what you are looking for, it would be a guess work. Could you create a sample qvw and share here explaining the expected output with logic?

Re: How to write a set expression

Mon, 01 Jun 2015 09:33:37 GMT

Thanks Tresesco.

Re: How to write a set expression

ankitaag — Mon, 01 Jun 2015 12:36:42 GMT

Hi,

Current Period sales as in Current Calendar Year or month or CurrentFinancial Year?

Make a variable vYear for the current year or Financial Year (according to your requirement)

Expression would be :

sum({<Year={'$(vYear)'},StoreOpen={">(15)"},StoreKey-={2}>}Sales)