Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register 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!