topic Re: pls help in QlikView

pls help

Fri, 17 Jan 2014 12:02:39 GMT

hi,

pls tell me what is the meaning of this statement.

num(sum( {$<STOCKYEAR= {'$(Vyera)'},STOCKMonth = {'$(Vmonth)'} ,YEAR=,MONTH=>} STOCK ),'#,##0')

marcus_malinow — Fri, 17 Jan 2014 12:19:52 GMT

Dushan

first off you have a num statement - this is there simply to format the result of the inner 'sum' expression as an integer.

the sum expression

- this is creating a sum of the field STOCK

- it contains a set analysis expression, the part within the {$< .... >}

- the set analysis is respecting your field selections except:

STOCKYEAR is being set to the value of the variable Vyera

STOCKMonth is being set to the value of the variable Vmonth

selections in the fields YEAR and MONTH are being ignored

Hope this helps.

Marcus

Fri, 17 Jan 2014 12:25:31 GMT

hi, I dont want to ignore YEAR and MONTH. How can I write this?

marcus_malinow — Fri, 17 Jan 2014 12:28:35 GMT

The parts of the set analysis expression that are causing those field selections to be ignored are these:

YEAR=,MONTH=

If your chart contains YEAR and MONTH as dimensions this may be the reason for the selections to be ignored

Sat, 18 Jan 2014 03:26:17 GMT

Thanks Marcus