topic Re: expression in set analysis in QlikView

expression in set analysis

Fri, 04 Apr 2014 10:10:12 GMT

Hi All

I have a problem with expression in set analysis.

If I write:

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ '1Q 12' } >} crrId)

it works well.

If I write

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ $ ('1Q ' & right(Year,2)) }>}crrId)

where Year =2012, it doesn't work.

What's wrong?

Thanks

Luca

Re: expression in set analysis

tresB — Fri, 04 Apr 2014 10:16:10 GMT

Try putting an equal sign and quotes, like:

Quarter ={" $ (='1Q ' & right(Year,2))" }>}

Re: expression in set analysis

MK_QSL — Fri, 04 Apr 2014 10:20:03 GMT

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ "$ (='1Q ' & right(Year,2))" }>}crrId)

Re: expression in set analysis

Fri, 04 Apr 2014 10:20:44 GMT

thanks for your reply, but doesn't work, I have 0 (result has to be 4)

Re: expression in set analysis

tresB — Fri, 04 Apr 2014 10:22:33 GMT

That could be checked if you could post your sample app here.

Re: expression in set analysis

sushil353 — Fri, 04 Apr 2014 10:22:36 GMT

Hi,

Try this:

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={' $ ('1Q ' & right(Year,2))' }>}crrId)

HTH

Sushil

Re: expression in set analysis

Fri, 04 Apr 2014 10:37:34 GMT

Thanks

but I still have 0..

Re: expression in set analysis

rustyfishbones — Fri, 04 Apr 2014 10:39:05 GMT

Try sharing the App so we can take a look

Re: expression in set analysis

sushil353 — Fri, 04 Apr 2014 10:42:13 GMT

One more try to the below.. if that wont work it is better to post app

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={' $ ('1Q ' & '$(=right(Year,2))')' }>}crrId)

HTH

Sushil

Re: expression in set analysis

arjunkrishnan — Fri, 04 Apr 2014 10:45:16 GMT

Hai Frd Pls Snd Sample Qvw

Re: expression in set analysis

CELAMBARASAN — Fri, 04 Apr 2014 10:46:27 GMT

Hi,

Try

Count(DISTINCT {$<RulesType={'NOT_OVERRIDE'}, Quarter ={ '1Q $(=right(Year,2))' }>}crrId)

Above will work if Year is a variable or Year field has only one value selected.