Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If (type ='abends', (5*count()),if(type ='alerts', (10*ckunt(),count())))
Try
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.