topic Re: Error in expression - Set Analysis in QlikView

Error in expression - Set Analysis

Mon, 08 Feb 2016 16:27:14 GMT

Hello

I am getting the error for the following Expression

Can you guys please help me to understand the reasons?

I Need the no of Customers (KP.EMM-ID)

where the Booking Type = 'reward order' and the max no of orders <=3

Many thanks

Sonja

Re: Error in expression - Set Analysis

petter — Mon, 08 Feb 2016 16:45:42 GMT

You can't have the expression like this:

$(dvRewOrders) <= {'3'}

Still is a valid syntax although It don't know if it will work for you:

aUniqueKey = {"=$(dvRewOrders)<=3"}

but it also depends on the content of the variable dvRewOrders

Re: Error in expression - Set Analysis

Fri, 12 Feb 2016 11:08:17 GMT

This Expression OK but the result '0'

=Count(Aggr(only( {<[C005.Booking Type.TEXT] = {'reward order'} count([C005.Booking ID]<='3')), [KP.EMM-ID]))

I Need the no of Customers (KP.EMM-ID)

where:

the Booking Type = 'reward order' and the max no of orders <=3

any ideas for my

thanks

Re: Error in expression - Set Analysis

sunny_talwar — Fri, 12 Feb 2016 19:18:39 GMT

Would you be able to share a sample to look at your datamodel?

Re: Error in expression - Set Analysis

Sun, 14 Feb 2016 12:27:01 GMT

Attached you will find a sample with data

Many thanks

Re: Error in expression - Set Analysis

maxgro — Sun, 14 Feb 2016 19:02:10 GMT

maybe

=Count( {$ <[Customer-ID]={"=count({$ <[Booking Type]={'Reward Order 1'}>} [Booking ID])<=3"}>} distinct [Customer-ID])

Re: Error in expression - Set Analysis

Oleg_Troyansky — Sun, 14 Feb 2016 19:08:58 GMT

If you are wondering what it means and how it works:

This is an Advanced Search criteria within the Set Analysis condition. Advanced Search (enclosed in double quotes and begins with the equals sign "=") allows evaluating ANY logical conditions in the context of the field. In this formula, the number of reward orders is evaluated for each Customer, and the result is compared to 3.

Come and learn advanced Set Analysis from my lecture at the Masters Summit for Qlik!

cheers,

Oleg Troyansky

Re: Error in expression - Set Analysis

sfatoux72 — Sun, 14 Feb 2016 21:07:57 GMT

I think it's what you want (in orange).

Re: Error in expression - Set Analysis

brijesh_fofadiy — Mon, 15 Feb 2016 07:12:45 GMT

First you have to create a variable to store no. of orders and after that You have to write like this :

count({$<[C005.Booking Type.TEXT] = {'reward order'},Orders={'<=$(dvRewOrders)'}>}[KP.EMM-ID])

It will run properly.

Thanks,

Brijesh

Re: Error in expression - Set Analysis

rajeshforqlikvi — Mon, 15 Feb 2016 07:26:30 GMT

$(dvRewOrders) = { < '3'}

Thanks & Regards

Rajesh Kumar

Re: Error in expression - Set Analysis

Mon, 15 Feb 2016 07:29:02 GMT

Yes, many thanks, Sebastien Fatoux!!