Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Regarding Syntax

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

1 Solution

Accepted Solutions
Not applicable

Regarding Syntax

Try This:

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

2 Replies
Not applicable

Regarding Syntax

Try This:

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

Not applicable

Regarding Syntax

Thank you alot Erika, that worked perfect :~)

Community Browser