Qlik Community

New to Qlik Sense

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

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 

Sparklines with Vizlib Table extension

Hi I am working in Qlik sense and I needed to show sparklines for a YTD trend for certain branch regions' deposit amounts. Branch regions consist of "Central","South","Other", and null. I am able to show a sparkline for each region, but when I use an if statement as a dimension to combine Null and "Other" it displays the rows perfectly except the sparklines disappear. The if statement I am using is: " =if(isNull ([Branch Region]), 'Other', [Branch Region])". This error seems to occur whenever I try to use an if statement as a dimension even though it shows the correct data. I was wondering if anyone else has experienced this or knows a way around it.

I hope that makes sense and I will provide some sample data as well, but any data can be used to create a sparkline and test an if statement. Any help is appreciated!

0 Replies