topic Re: Less than variable in set analysis in QlikView

Less than variable in set analysis

annabergendal — Thu, 30 Oct 2014 11:41:10 GMT

I have a problem in my set analysis, when trying to get all values prior to a period.

It works to include all values within this period:

count( {$<ÅrVecka={'$(vPreviousWeekYear)'}>} distinct CustomerPortLabel)

But this returns zero:

count( {$<ÅrVecka = {'<= ${=vPreviousWeek}'}>} distinct CustomerPortLabel)

What am I doing wrong?

Thanks

Re: Less than variable in set analysis

rubenmarin — Thu, 30 Oct 2014 11:44:26 GMT

Not sure if it's a typo, try:

count( {$<ÅrVecka = {'<= $(=vPreviousWeek)'}>} distinct CustomerPortLabel)

Re: Less than variable in set analysis

ashfaq_haseeb — Thu, 30 Oct 2014 11:47:34 GMT

Hi,

Try like this

count( {$<ÅrVecka = {'<= ${=vPreviousWeek}'}>} distinct CustomerPortLabel)

count( {$<ÅrVecka = {"<= ${=vPreviousWeek}"}>} distinct CustomerPortLabel)

Regards

ASHFAQ

Re: Less than variable in set analysis

jonathandienst — Thu, 30 Oct 2014 11:48:49 GMT

The expression that works uses vPreviousWeekYear; the one that does not uses vPreviousWeek.

HTH

Jonathan

Re: Less than variable in set analysis

Colin-Albert — Thu, 30 Oct 2014 11:48:50 GMT

Try

count( {$<ÅrVecka = {'<= $(vPreviousWeek)'} >} distinct CustomerPortLabel)

You should only need $(variablename) to evaluate the variable, not $(= variablename)

Re: Less than variable in set analysis

Thu, 30 Oct 2014 11:49:52 GMT

Hi,

Just remove { } and place the variable in ( )

count( {$<ÅrVecka = {'<= $(=vPreviousWeek)'}>} distinct CustomerPortLabel)

Re: Less than variable in set analysis

its_anandrjs — Thu, 30 Oct 2014 11:52:00 GMT

What is the definition of vPreviousWeek or you use wrong brackets like { } this remove it with ( ) for variable only

Count( {$<ÅrVecka = {'<= $( =vPreviousWeek )'}>} distinct CustomerPortLabel)

Count( {$<ÅrVecka = {"<= $( =vPreviousWeek )"}>} distinct CustomerPortLabel)

Count( {$<ÅrVecka = {'<= $( =Week(Today())-1 ) '}>} distinct CustomerPortLabel)

Regards

Anand

Re: Less than variable in set analysis

annabergendal — Fri, 31 Oct 2014 16:08:06 GMT

You are right, I misspelled it, but they are both spelled vPreviousWeekYear in the app

Re: Less than variable in set analysis

annabergendal — Fri, 31 Oct 2014 16:12:17 GMT

Thanks for all the advices, but none of these worked. I ended up using another syntax in the end with Date:

count( {$<Datum={"<$(=Date(weekstart($(vToday)),'YYYY-MM-DD'))"}>} distinct CustomerPortLabel)

Don't ask me why this worked and the others did not... Some kind of syntax problem with the variable vPreviousWeekYear I guess, even though the other comparison worked.

Re: Less than variable in set analysis

ashfaq_haseeb — Fri, 31 Oct 2014 16:45:41 GMT

Hi,

Can you post sample to look over.

Regards

ASHFAQ