topic Re: Help on Set analysis in QlikView

Help on Set analysis

Fri, 10 Oct 2014 06:28:10 GMT

Hello,

I want to get the result using 3 sets

count( {<expr1> + $<expr2> - <expr3>}id)

How is this evaluated ?

I am looking for the values from (<expr1> + $<expr2> ) excluded with (<expr3>)

Kindly help me to understand.

Thanks,

Deepa V

Re: Help on Set analysis

alexandros17 — Fri, 10 Oct 2014 06:32:43 GMT

count( {$ <year={2010,1011}-{2000}>}id)

this is an example but to help you add more detai

Re: Help on Set analysis

senpradip007 — Fri, 10 Oct 2014 06:34:02 GMT

Can you share your expression?

Re: Help on Set analysis

Fri, 10 Oct 2014 06:44:17 GMT

Hi,

Below is the expression.

count({ $*<BREAKAGE_DESCRIPTION = {"*"}> + <BREAKAGE_DESCRIPTION = {""}> - <flagDate = {""}>} Id))

Thanks,

Deepa V

Re: Help on Set analysis

jonathandienst — Fri, 10 Oct 2014 07:04:16 GMT

Are you trying to find nulls in BREAKAGE_DESCRIPTION and/or flagDate? If that is the case, then you cannot use a set expression. You will need something like this:

Count(If(Len(BREAKAGE_DESCRIPTION) > 0 Or (Len(BREAKAGE_DESCRIPTION) = 0 And Len(flagDate) > 0), Id))

which will simplify to this:

Count(If(Len(BREAKAGE_DESCRIPTION) > 0 Or Len(flagDate) > 0, Id))

If the Count(if()) performs badly, then you can create a null flag during the LOAD and use that in a set expression. Or you could use NULLASVALUE on the two fields to convert nulls to empty strings.

HTH

Jonathan

Re: Help on Set analysis

jonathandienst — Fri, 10 Oct 2014 07:06:39 GMT

If the set expression is searching/excluding for empty strings, then this might be what you need:

Count({<BREAKAGE_DESCRIPTION -= {""}> + <BREAKAGE_DESCRIPTION = {""}, <flagDate -= {""}>} Id))

Re: Help on Set analysis

Fri, 10 Oct 2014 07:10:36 GMT

Hi,

There is a list box with BREAKAGE_DESCRIPTION

When some value is selected , then i need count on selected BREAKAGE_DESCRIPTION and also count of BREAKAGE_DESCRIPTION with nulls

With the above result

I want to eliminate the data with Flagdate NULL

Kindly suggest.

Thanks,

Deepa

Re: Help on Set analysis

jonathandienst — Fri, 10 Oct 2014 08:29:09 GMT

Count(If(Len(BREAKAGE_DESCRIPTION) > 0 Or Len(flagDate) > 0, Id))

(eliminate null flagDate if BREAKAGE_DESCRIPTION is also null)

Count(If(Len(BREAKAGE_DESCRIPTION) > 0 And Len(flagDate) > 0, Id))

(eliminate anything that has a null in either field)