Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Count invalid Expression

I need to calculate Count of flag  but count expression is invalid

Calc_Temp:

Load
    Year,
    Name,
    Role,
    Group,
    "Domain/Department",
    QuestionGroup,
    Weightage,
    Questions,
    Ques_Calc,
    Rating as Rating_Raw,
    1 as Flag,
    Count(Flag)
    Resident RawData
    Group By Year,Name,QuestionGroup;

1 Solution

Accepted Solutions
Master II
Master II

@mnvrma  and ?

 
    Data:
    Load
    Year,
    Name,
    Role,
    Group,
    "Domain/Department",
    QuestionGroup,
    Weightage,
    Questions,
    Ques_Calc,
    Rating as Rating_Raw,
    1 as Flag 
   Resident RawData
   left join load  Year,Name,QuestionGroup, Count(Flag) as count_Flag resident Data  Group By Year,Name,QuestionGroup;
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Master II
Master II

@mnvrma  and ?

 
    Data:
    Load
    Year,
    Name,
    Role,
    Group,
    "Domain/Department",
    QuestionGroup,
    Weightage,
    Questions,
    Ques_Calc,
    Rating as Rating_Raw,
    1 as Flag 
   Resident RawData
   left join load  Year,Name,QuestionGroup, Count(Flag) as count_Flag resident Data  Group By Year,Name,QuestionGroup;
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Partner
Partner

Hello Sir @Taoufiq_Zarra 

Can you please go through this post as I am facing little challenge in requirement 

Link: Calculate Rolling Sales according to Max Date available for each Shop