topic Re: Set Analysis in QlikView

Set Analysis

naziralala — Sat, 13 Jun 2015 17:00:44 GMT

Hi All,

I am getting an error as "error in set modifier ad hoc element list"

Can someone help me with what is possibly wrong..

=Num(Sum({<Year ={$(V_Year)}>} [Net Sales]),'#,##0')

I have defined V_Year as a variable with defn Max(Year)

The below is not giving error but displays a zero for previous year

=Num(Sum({<Year ={$(V_Year-1)}>} [Net Sales]),'#,##0')

swuehl — Sat, 13 Jun 2015 17:10:51 GMT

What do you get when you create a text box with Text:

=V_Year

satishkurra — Sat, 13 Jun 2015 17:13:19 GMT

Modify as below and give a try

=Num(Sum({<Year ={$(=(V_Year)-1)}>} [Net Sales]),'#,##0')

antoniotiman — Sat, 13 Jun 2015 17:22:26 GMT

Define Variable v_Year as

=Max(Year)

naziralala — Sat, 13 Jun 2015 17:24:12 GMT

This is displaying a 0

On Sat, Jun 13, 2015 at 1:13 PM, Satish Kurra <qcwebmaster@qlikview.com>

naziralala — Sat, 13 Jun 2015 17:24:48 GMT

This is displaying correct value

naziralala — Sat, 13 Jun 2015 17:26:36 GMT

Thanks.

I had to put the =Sign.

It resolves my problem.

On Sat, Jun 13, 2015 at 1:22 PM, ANTONIO MANCINI <qcwebmaster@qlikview.com>