topic Re: requirement in QlikView

requirement

Anonymous — Fri, 09 Feb 2018 10:15:44 GMT

I have a expression like:

count(id)

I have created a variable which is picking up my latest date from my date field

now I want to use it over here with this expression,

how to do that?

Re: requirement

tresB — Fri, 09 Feb 2018 10:26:14 GMT

May be like:

=Count( {<Date={'$(vMaxDate)'}>} id)

Re: requirement

Anonymous — Fri, 09 Feb 2018 10:36:49 GMT

I have one more condition to add in this

:field={y}

how to do that

Re: requirement

tresB — Fri, 09 Feb 2018 10:39:21 GMT

=Count( {<field={'y'}, Date={'$(vMaxDate)'}>} id) Set Analysis: syntaxes, examples

Re: requirement

Anonymous — Fri, 09 Feb 2018 11:30:19 GMT

load id

where

field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (curr_ele_brand<>'null' or field5<>'null')

cnvert this to set analysis how?

Re: requirement

tresB — Fri, 09 Feb 2018 12:08:38 GMT

If your original query is answered to your satisfaction, please close it by marking correct/helpful as applicable.

Few suggestions:

put a proper caption/heading to your query unlike 'requirement'; that would help you get answer faster and better may be.
don't continue one answered thread with a another query.
mark helpful/correct replies as fit - to keep people motivated to help you.
when you post a query, try to be more descriptive about your problem and support your case with sample app and/or sample data.

I guess, I have already replied to your similar query couple of hour back and you didn't confirm it it was helpful or 'not working'. Try to continue with that thread..set analsis expre