The difficulty is that the image (jpg) is stored as a value in an Oracle DB.

The image value is in hexadecimal (Start with FFD8FFE0…).

I cannot found a way to display the image on Qlik Sense.

How to display the image from the field value ?

Hi All.

Having done some research I suspect I cannot get to what I want to achieve here, but this community has been great at helping so here goes.

I want to produce a table which is formatted in a more grouped manner (similar to a Pivot Table maybe), but rather than showing measures in the columns I need to show Dimensions - see example:

In my ideal output rows would be grouped by the Category with the 'Controls' grouped by category (e.g. - Asset Ownership).

Is there functionality in Qlik to do this, or if not are you aware of a extention which might help?

Thanks once again.

Mark.

I am trying to download data from hubspot

loop is not getting all only first set

every time i need to pass output value to URL using this variable (vRowCount)

i test with postman 

Hi, this has been driving me nuts and wondered if anyone would be able to help.

So I have 2 tables, the first is in a table chart on a sheet, and I need to retrieve 2 fields from the 2nd one using set analysis:

In the first table for Analysis 1, I have the following at it works great to retrieve the max date value:

=MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))

In Analysis 2, I need the corresponding Field 6 that matches the Max Date.

My latest attempt was to use this as a nested set analysis without aggregation, but it returns blanks for all records:

ONLY( {$< [Field 5] = {"MAX( {$<[Field 4] = {'AAA'}>} DATE( [Field 5], 'dd-MMM-yyyy'))"}>} [Field 6])