Embed the Images based upon the value in the 'Stra... - Qlik Community

Report Inappropriate Content · ‎2013-09-19

I am Trying to Embed the Images in the Straight table based upon the Value Selected. How ever It is not allowing me to select as the whole table is turning blank whenever I do so.

For the Straight table Under the Expressions I am selecting the option as Image and trying to pass a variable which has set of Images, where variable has list of Images predefined from the Image Folder. Still the solution don't seem to be achieved.

Also Does any one know where in the Folder I can put the new Images for me to get access to them from the Qlikview Images option.

Josh_Good · ‎2013-09-19

Can you please post the QVW or a sample. It sounds like you have some minor syntax issue.

Report Inappropriate Content · ‎2013-09-19

Hi Josh -

Thanks for the Reply, I figured out the Partial Issue, the reason that there was nothing showing is because I am using the integers 9,8,7,6,5,4,3,2,1,,,, but the numbers I am getting are Integers. Can you tell me if there is a way to specify the bandwidth in the code below to capture the values as integers Ex: 8.3, 7.6, 2.34 etc

I correct code and correct syntax I was using is below:

=Pick(Match(Avg(MetricStatus),9,8,7,6,5,4,3,2,1),

'qmem://<bundled>/BuiltIn/arrow_n_g.png',

'qmem://<bundled>/BuiltIn/arrow_e_g.png',

'qmem://<bundled>/BuiltIn/arrow_s_g.png',

'qmem://<bundled>/BuiltIn/arrow_n_y.png',

'qmem://<bundled>/BuiltIn/arrow_e_y.png',

'qmem://<bundled>/BuiltIn/arrow_s_y.png',

'qmem://<bundled>/BuiltIn/arrow_n_r.png',

'qmem://<bundled>/BuiltIn/arrow_e_r.png',

'qmem://<bundled>/BuiltIn/arrow_s_r.png')

Josh_Good · ‎2013-09-19

You will need to use the Round, Ceil, or Floor function depending on what behaviour you want. For example, assuming you want 8.6 to evaluated as 8 the expression would be:

=Pick(Match(floor(Avg(MetricStatus)),9,8,7,6,5,4,3,2,1),