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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
jyencha123
Contributor
Contributor

Multiplying the Count Expression

Very new to Qlikview and I have used this forum with good results but could not find this.

I created the simple table below.  It's a straight table not a pivot. Count is an Expression.

I want to add a dimension to the table or manipulate the Count(whichever is easier) base upon the value of Type.

For Abends,  multiply count by 5, Alerts Multiply by 10, etc....

I've been trying to add an additional expression with no luck, any help/suggestions would be much appreciated.

Jeff

Capture.PNG

2 Replies
Channa
Specialist III
Specialist III

If (type ='abends', (5*count()),if(type ='alerts', (10*ckunt(),count())))

 

Try 

Channa
jyencha123
Contributor
Contributor
Author

Is that answer more for the script that I use to load the data?

I'm trying to do it as a new dimension or expression when I create the table.