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])

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

I need to split the following table into a more readable format in the load statement.

From this

To this

Any ideas please?

Hello NPrinting Community!

Please check out this Blog post and article as soon as possible if you are considering upgrading QlikView to 12. 8 track.

https://community.qlik.com/t5/Support-Updates/QlikView-May-2023-release-and-Qlik-NPrinting-Do-not-upgrade/ba-p/2074371

https://community.qlik.com/t5/Official-Support-Articles/QlikView-May-2023-Compatibility-with-NPrinting/ta-p/2076472

Kind regards...

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.

Hi , I have a requirement to view a 24 month period on a pivot , but there should not be a scroll.

Isthere a way to disable the scroll on a pivot?

Hi Dears,

we're facing an issue with upgrading Qlik Sense 2021, 

First, I'm unable to upgrade Qlik sense duo to PostgreSQL 9.6.

I tried to Upgrade the PostgreSQL 9.6 with the current available version in the download section but all of the available versions not compatible with the current PostgreSQL 9.6.

Kindly, any idea how to upgrade the PostgreSQL 9.6 or if you have the download link for the compatible version with 9.6 before I upgrade to the latest.

I have the following along with qliksenseserver 14.20.10

• About Service 1.28.0
• App Migration Service 4.12.2
• Bot Channel Service to enable chat experience through channels like Slack/Teams 1.19.0
• Broker Service 5.35.0
• Capability Service 1.9.1
• Client 7.233.12
• Cross-applications search for nl questions 1.16.0
• Data Preparation Service 3.316.3
• Dependency Graph Service 1.2.0
• Dev Hub 1.21.0
• Download Preparation Service 1.2.5
• Freya Client Service 2.13.0
• Licenses service 3.81.0
• Mobility Registrar Service 1.1.0
• Monitoring Apps 8.7.0
• Natural-language broker, a front-facing API for NL utterances 3.14.5
• Natural-language understanding parser service 0.105.5
• Notifier service 1.2.0
• ODAG Service 3.20.1
• Precedents Service 3.7.0
• Printing Service 15.31.0
• Proxy 14.6.0
• QDC Catalog Service 0.20.2
• QIB Webchat Service 1.6.1
• QIX Engine 12.969.6
• Qlik DataMarket Connector 2.11.0.28
• Qlik Essbase Connector 1.5.0
• Qlik Management Console 1.95.1
• Qlik ODBC Connector 6.118.2
• Qlik REST Connector 2.82.0
• Qlik SalesForce Connector 15.74.0
• Qlik Sense Hub 0.57.4
• Qlik Web Connectors 4.3.5
• Repository 28.0.6
• Scheduler 19.4.0
• Service Dispatcher 15.17.0
• Web Extension Service 1.10.0
• Web Extensions 1.6.0