topic Re: How to write this in set analysis? in QlikView

How to write this in set analysis?

jim_chan — Tue, 02 Aug 2016 16:10:39 GMT

hi guys,

I have a formula here, can anyone help me to change to set analysis?

If((not (IsNull(grp_cust_id) and IsNull(trip_end_date))),count(trip_id)) - it works in IF statement by the way.

Rgds,

Jim

Re: How to write this in set analysis?

trdandamudi — Tue, 02 Aug 2016 16:14:52 GMT

May be as below:

Count({<Len(Trim(grp_cust_id))>{'0'},Len(Trim(trip_end_date)={'0'})>} trip_id)

Count({<grp_cust_id={'*'},Len(Trim(trip_end_date)={'0'})>} trip_id)

Re: How to write this in set analysis?

Anonymous — Tue, 02 Aug 2016 16:17:46 GMT

Would create flags in script for both null scenarios then use the flags in the set analysis

set analysis something like count({<[grp_cust_id_flag]={'Y'},[trip_end_date_flag]={'Y'}>}trip_id)

Re: How to write this in set analysis?

jim_chan — Tue, 02 Aug 2016 16:20:18 GMT

Hello Thirumala,

there modifier expression error.

Rgds,

Jim

Re: How to write this in set analysis?

jim_chan — Tue, 02 Aug 2016 16:20:34 GMT

ok.. will try it out .

Re: How to write this in set analysis?

sunny_talwar — Tue, 02 Aug 2016 16:22:56 GMT

May be this:

Count({<grp_cust_id)) = {'*'}> + <trip_end_date = {'*'}>} trip_id)

Re: How to write this in set analysis?

trdandamudi — Tue, 02 Aug 2016 16:23:47 GMT

Give a try on the below:

Count({<Len(Trim(grp_cust_id))={'>0'},Len(Trim(trip_end_date)={'0'})>} trip_id)

Count({<grp_cust_id={'*'},Len(Trim(trip_end_date)={'0'})>} trip_id)

Re: How to write this in set analysis?

trdandamudi — Tue, 02 Aug 2016 16:26:49 GMT

Sunny,

grp_cust_id should be not null and trp_end_date should be null, I think you need to modify the expression..

Re: How to write this in set analysis?

jim_chan — Tue, 02 Aug 2016 16:28:57 GMT

this works. -

Count({<grp_cust_id = {'*'}> + <trip_end_date = {'*'}>} trip_id)

Re: How to write this in set analysis?

sunny_talwar — Tue, 02 Aug 2016 16:29:20 GMT

I think Not is over-arching both the fields grp_cust_id and trp_end_date

If((not (IsNull(grp_cust_id) and IsNull(trip_end_date))),count(trip_id))

Re: How to write this in set analysis?

sunny_talwar — Tue, 02 Aug 2016 16:30:33 GMT

Awesome

Re: How to write this in set analysis?

trdandamudi — Tue, 02 Aug 2016 16:31:07 GMT

Yup... overlooked at it..

Thanks..