topic BASICS OF WRITING A SYNTAX in QlikView

BASICS OF WRITING A SYNTAX

Mon, 27 Feb 2012 05:24:29 GMT

PLEASE TELLL ME HOW TO WRITE AN EXPRESSION?

BASIC SYNTAX OF AN EXPRESSION??

FOR EXAMPLE

SUM({$<COLUMN1={A,B}>} COLOUMN2)

WHAT MUST BE USED AS COLUMN1 AND COLUMN2???

BASICS OF WRITING A SYNTAX

Mon, 27 Feb 2012 05:29:51 GMT

Column1 is a filter.

Assume that Column1 contains Name as A,B,C,D,... and Column2 contains their respective salary as 100,200,300,400,...

Suppose I want to add salaries of only A and B then expression will be

SUM({<Column1={"A","B"}>}Column2)

Suppose I want to add salaries of all people excluding A and B then expression will be

SUM({<Column1 - ={"A","B"}>}Column2)

I hope this clarifies understanding.

BASICS OF WRITING A SYNTAX

jagan — Mon, 27 Feb 2012 05:40:30 GMT

Hi,

in the expression Column1 is a filter, which excludes all other values and considers only A and B for calculation, Column2 is the field which is been summed up.

For example

SUM({<Year={'2011','2012'}>} Sales)

The above expression calculates the sum of Sales for the years 2011 and 2012.

Hope this helps you.

Regards,

Jagan.

BASICS OF WRITING A SYNTAX

jagan — Mon, 27 Feb 2012 05:42:57 GMT

Hi,

Hope the URL helps you in creating and understanding the expressions

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Regards,

Jagan.