0 Replies Latest reply: Nov 15, 2015 12:38 AM by Kristen Liu RSS

    Info function can't display image

      Hello

       

      I have following data :

       

      lifestylesales
      120
      210
      350
      120

       

      lifestylepath
      1D:\01 Qlikview\002 #Qlik Development#\01 SourceFiles\01 Deposit Dashboard\Photo\dining.jpg
      2D:\01 Qlikview\002 #Qlik Development#\01 SourceFiles\01 Deposit Dashboard\Photo\shopping.jpg
      3D:\01 Qlikview\002 #Qlik Development#\01 SourceFiles\01 Deposit Dashboard\Photo\travel.jpg

       

       

      I want to display the image of the top 2 lifestyles , below is my expression in the textbox:

      # No. 1 Lifestyle :

      =FirstSortedValue(lifestyle, -aggr(sum(sales),lifestyle))

      >>> it shows 3

       

      # No. 2 Lifestyle :

      =FirstSortedValue(lifestyle, -aggr(sum(sales),lifestyle),2)

      >>> it shows 1

       

      Problem :

      However, I want it to be displayed in image instead of lifestyle number , so I write below :

      # No. 1 Lifestyle :

      =info(FirstSortedValue(lifestyle, -aggr(sum(sales),lifestyle)))

      but I receive the below error message:

      Info function takes a valid field name as parameter .

      Please help me of displaying images without selecting lifestyle in the listbox. Thank You.