HI All,

I am looking for some reference dashboard on Real estate sector analytics.

I am working for a Bank in Real estate finance section, and I am creating analytical dashboard for the region based on the data we have. 

Looking for similar dashboard to take idea and design.

Thanks in advance.

Hello,

I have created a Nprinting report based on a Qlik Sense table.

This table shows daily amounts. The behavior is correct in qlik sense as it shows me all the values for each single day.

I then created a table via pixel perfect on nprinting but somehow whenever the result of my first column is 0, the line is not shown. I did not activate anything special and I do not understand such behavior.

Nprinting:

Qlik Sense:

Can anyone help?

Thank you.

Hi all. I have a sample table below

I am trying to calculate the weighted average of the same category but I am not sure how to do this.

What I have thought of was

SUM(hrs * COUNT(cat)) / COUNT(cat)

However I am not sure how to approach the bold part to get the count of each cat.

My goal is to use this set expression in a bar chart to display the data.

Any help is greatly appreciated, thank you.

I Installed data movement on linux that Redhat8 of AWS EC2.

I’m trying connect to Oracle database with data integration. but when push test connect button then get about proxy error.

Checking the data movement log file,there is about proxy error following

[ERROR] Error connecting to Replicate server 'local_repsrv'
System.Net.WebException: The proxy tunnel request to proxy 'My proxy adress' failed with status code '307'."

Do you have any good solutions in regards to that?

best regard.

Hello, 
Can you please advice me right solution, how to realize "outer apply with top 1" in qliksense? 

I have 2 tables in qvd files (Sales and Price list)
I need to get result table: Sales + Price on document date

1. Sales 

2. Price list 

in sql i can do next: 

select
	sales.date,
	sales.nr,
	sales.product,
	sales.qty,
	pricelist.price
from
	sales
	outer apply (
		select top 1
			pricelist.price
		from
			pricelist 
		where
			pricelist.product = sales.product
			and pricelist.date <= sales.date
	) as pricelist
	

Result table by sql:

but how to do same in qliksense? 
left join or applymap with date condition? 

Hello all,

I have a  line chart that has an X axis as a continuous date field and the Y axis is the number of outstanding jobs remaining to complete the project.  The data set used to build this looks something like this:

and so on and so forth over a period of about 90 days.

The line chart is working well, no issues there, however I have been asked to add in reference lines for key events/milestones that are listed on a separate data table that looks like this:

My initial thought was to code in an index column and then create an individual measure for each Milestone's date. Then I would just add each reference line separately based on each measure.

The problem with that methodology is that depending on the file (this data gets refreshed daily), the number of milestone events that need to be captured as reference lines may change. One day there may be more, another day there may be less.

Can someone please advise a way forward to add this functionality? We are capable of doing data wrangling, etc. out of Qlik in Databricks if need be.

can any one help me to  connect  AWS aurora PostgreSQL from Qlik cloud(SAAS) by using   Native Postgre SQL connector.

I'm getting timeout error like below . Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Communication link failure.  i'm able to configured successfully in PGAdmin4 by providing same credentials ,Host Name and port number.

Please help me out, do i need to do any additional configuration . 

Thank you in Advance..!

James Fisher, the Chief Product Officer, had the opportunity to collaborate with Dez Blanfielf from Sociaall. 

Watch what James and Dez talked about on what to expect at QlikWorld 2023 and a teaser of what his keynote on innovating the management of your data will cover! 

“It’s the opportunity to get everybody back together again, to be in the same room, to you know, see everybody from a different point of view instead of you know just sort of in shoulder high as we have been doing on Zoom for so long.” - James Fisher  

Don’t forget to register for QlikWorld in Las Vegas from April 17th – 20th, 2023 to see James and Dez in person and hear James live! 

Links:  

James Fisher – Twitter: https://twitter.com/dez_blanchfield/status/1638411049341964291 

James Fisher – LinkedIn: https://www.linkedin.com/posts/dezblanchfield_james-fisher-chief-product-officer-at-qlik-activity-7044177267115061249-Mavi 

@ella-c @JamesFisher 

Hi Everyone,

I would like to ask about this:

1. Can we set the report in parallel? For example, we have 8 different reports and we like to sync the reports in parallel. Any recommendation on report synching?

Thank you.