Regarding Syntax

Fri, 20 May 2011 07:28:07 GMT

Hello Everyone,

I wrote a small piece of code to sum records in a column based on the grouping. For example I have four groups in a column called TYPES -A, B ,C & D and each TYPE further has four further groupings say 1,2,3 &4 and the column for them is have given is GROUP . I am using a pivot table & My requirement is I have added a column called OVERALL_COUNT and the folowing expression which works fine.

=sum(total <GROUP> TOTAL_VALUE), to this I want to add few conditions like FACT='Current' & REPORT_STATUS="Active".

I need help to write the syntax.

FYI- Overall_Count adds the total value of A-1 + B-1 + C-1+D-1, and A-2+B-2+C-2+D-2 and so on

Thanks a lot,

With warm regards,

Bikash

Regarding Syntax

Fri, 20 May 2011 07:39:00 GMT

Try This:

sum({<FACT={"Current"}, REPORT_STATUS={"Active"}>}total <GROUP> TOTAL_VALUE)

Regarding Syntax

Fri, 20 May 2011 07:55:30 GMT

Thank you alot Erika, that worked perfect :~)

topic Regarding Syntax in QlikView

Regarding Syntax

Regarding Syntax

Regarding Syntax