Welcome to Qlik Community

  Do the tables need to be joined?

Example:  

Table 1:

Country  Hospitals
USA           St Francis Hospital
USA           Thomas Jefferson Med. Center
Canada     Montreal Medical Center




Table 2:

Country  Num_of_Patients
USA           250,000,000
Canada    90,000,000




There are other visualization platforms where I can load the two tables without joining them, and then define the filters to control elements in both tables.  

Is this possible in Qlik Sense?  Or do I need to join the tables when I load the data?

If I do join the tables, do he joined fields have to have the same exact name?  Or is there a way to define them to be the same field?  (ie Country in one table might be called Country_Name in another).

Thanks!

Hi everyone,

I ran a qlikview document to load data from my excel spreadsheet but noticed that some of the strings in a column was truncated. (for example: 'Lee Hartman & Sons' became ' Sons').

When I go to the excel document, copy that field, paste value to a new column and delete the old one, then reload the qlikview document, it works correctly.

I suppose it's some setting in that excel column that doesn't work well with Qlikview. Does anyone know what might have caused this? I don't want to manually change this every time.

Thank you!

Hi, 

I am working on some reports with an excel template that we need to send out as PDF Reports attached to an email. Some users may receive a single report while others may receive multiple reports in the same email. 

When I first began working on these reports, I sent out an email to myself to make sure the variables in the email body worked and the attachment was just the report itself as a pdf. However, now when the reports get sent out, whether its a single report or multiple reports, the attachment is a .zip file. 

We shifted these reports from NPrinting16 so the end users are used to and prefer receiving these reports as PDFs attached to the emails they receive. I was unable to find a way to change the attachment type and was wondering if anyone has any suggestions as to how I can remove the .zip file and just keep the PDF attachment.

Thank you!

Hi,

I need to be able to have a paired bar chart where 1 bar can be filtered by year BUT is always the average for all responses. The other bar can be filtered by year and is specific company response.  Currently my expressions are;

Group Average:  = avg ( distinct {1<QPermID={"AM0425_R*"}>} Response)

Company Response:  = MAX( distinct {$<QPermID={"AM0425_R*"}>} Response)

If I want to change the year, the Company Response responds as expected.  I can filter by a specific company and a specific year.  However, with a set expression of '1', my Group Response doesn't change.  

In other expression in my app, I use the orange expression below. This allows the Group response to always be the max year and it will also change to whatever is the max year that I've selected in my filter...

=(Avg({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(Sum({1<QPermID={"AM0425_R_1*"}>}Response),YearID,Year)))

I have tried placing {1<Year = {$(=Max(num#(Year ,'####')))}>} into my group and company responses for the paired bar, but they are ignored.  The expression isn't broken, it just doesn't get applied. That means my Group Average is always inclusive of all years of data. 

In my example App,

• Sheet 1 "Example Bar" shows the data.  It's already set to max year.  The average for that data is 46.4.
• Sheet 2 "Paired Bar" shows my objective graph.  The average for the far left bar should also be 46.4.  However, because it doesn't respond to filter nor my Max Year expression ({1<Year = {$(=Max(num#(Year ,'####')))}>}) it's using all year's data and instead results in an average of 52.8.

I'm open to a whole new expression as long as it gets me what I need.  Thanks

Can you please help me convert the 2 below sql scripts into load statements?

1)  Concat(CONVERT(VARCHAR,[Calendar Year]),iif(len(CONVERT(VARCHAR,[Calendar Month Number]))=            1,'0'+CONVERT(VARCHAR,[Calendar Month Number]),CONVERT(VARCHAR,[Calendar Month Number]))) AS YEAR_MONTH

2)  DATEADD(DAY, 2 - DATEPART(WEEKDAY, [Calendar Date]), [Calendar Date]) AS WEEK_BEGIN_DATE

Thank you in advance!

Saludos Colegas,

Alguien ha realizado Dashboard que realice cambio de divisas o monedas, osea de Euro a Dollars, si es posible porfavor orientarme.

Gracias