Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I've created pivot chart to sum the Cost_per_Enc field. In the database, this field is a decimal (18,2). In expression, I coded
=sum(Cost_per_Enc). In straight table, it displays proper $$ amount. It seems like Qlik is treating this field as varchar. How do I convert them so I can sum the field?
Thank you for your help in advance!
Di
Good morning yusuf,
I changed to proper DMISID and it worked. Thank you.
Di
I used the following set Analysis in Qlik Sense
sum({<color_code={"Red" }> } color_code) but getting 0 in color_code ( 4th column).
I should see only Red related rows. Where I am doing wrong?
Could you please tell how did you solve this?