Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
Creator
Creator

Scripting error : Count, Total & set analysis

hi there,

i can't seem to figure out where my error is, please refer to script below:

Count ( { < Type = {"Complaint"}  > } ([Origin of Complaint]))

/

Count (TOTAL <[Origin of Complaint]> ( { < Type = {"Complaint"}  > } ([Origin of Complaint])))



thanks!

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Here is the error.

Count (TOTAL <[Origin of Complaint]> ( { < Type = {"Complaint"}  > } ([Origin of Complaint])))


You have put extra brackets (Marked as Italic in above expression)

Try this.



Count (TOTAL <[Origin of Complaint]> { < Type = {"Complaint"}  > } ([Origin of Complaint]))


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Here is the error.

Count (TOTAL <[Origin of Complaint]> ( { < Type = {"Complaint"}  > } ([Origin of Complaint])))


You have put extra brackets (Marked as Italic in above expression)

Try this.



Count (TOTAL <[Origin of Complaint]> { < Type = {"Complaint"}  > } ([Origin of Complaint]))


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!