So I have an existing Qlik Sense application that I have already loaded data to and have created a whole bunch of charts for.  There is a field from an existing qvd that I need to add that I didn't have on my initial data load.  In other words, I only loaded 3 fields from a QVD for this application initially, but I need to add a 4th now.  I tried to add the field into the data load, but when I reload the data, the field is not showing up in the data tables.  What might I be doing wrong to add this field?  

I have a Qlik Sense app where I have dimensions for distributor name and distributor code plus one measure for sales.  I am trying to create a table that shows sales data using the distributor name when it is selected in the distributor name filter box or distributor code for the distributor names not selected.  I am using set analysis to show sales for all distributors regardless of the distributor name selections.  I need this to work if one or multiple distributor names are selected.

My Custom Connector is working pretty well. But for some reason when I'm pulling back results from 1 specific Saved Search that's a Transaction type (I have other Transaction types that work fine), I'm getting the below within the Log file.

002842 2020-03-27T10:47:34.647-04:00 Notice WriteTableItemsToStream() - Wrote: 5733 table items to stream
002843 2020-03-27T10:47:34.653-04:00 Debug HandleRequest(request:QVX_GET_EXECUTE_ERROR)

The 5733 items come back into Qlik without any issue. The issue is that it should be returning about 14,000 items instead.

It moves fast, no timeouts, and I can't find anything else anywhere suggesting what might be wrong.

Any help would be appreciated.

Thanks

Hi All!  Hoping for some help here.

I am new to QlikSense and have a clinical healthcare background not technical so I apologize if I use the wrong language here.

I am creating a dashboard to compare hospital discharge times across various sites.  On one sheet I am trying to create a comparison that shows all six sites without the end user having to make the selections.  For the patient count I am using the expression in a KPI of (count({<Organization={'Hospital A'}>}Organization)) which gives me the results of just that facility.  For the average time I am using a KPI with the expression avg(if([DC TAT]<5760,([DC TAT]))) which gives me the average but for all the facilities involved.

Essentially I trying to jam those two expressions together so I can have a KPI that shows the Avg DC TAT only when it equals Hospital A, Hospital B, etc..

I have tried various expressions and have googled like crazy but cannot seem to figure it out.  My guess is I need to use Aggr function but I cannot seem to get an expression that works correctly.

Any thoughts would be greatly appreciated! 

I have Price, Today() as Start Date and 10/25/2025 as EndDate

How do I generate months between Today() and EndDate, Add Price Per Month to each Month and show them in Years?

As an example

Current:

Result:

Hi,

when using calculated dimension with aggr it select the user,

here is my dimension:

=Aggr(FirstSortedValue(vp, -Date), user)

can i make it select the vp?

the result in the table is correct.

please find attached qvf

thanks.

ido.

Hello All,

can some one help me How to hide column when field values is empty. i have tried below expression its not working for me.

=if(Len( [Provider])=0,0,1)
=if(count( [Provider])=0,0,1)
if(count( [Provider])=null(),1,0)
sum([Provider])>0
If(Len(Trim([([Provider])]))<>0 , [([Provider])])

Regards,

Navin

Hi everyone,

Let assume I have a table that contains the following fields:

Account / Country / Region/ Sales

I want to make a bar graph that shows the Country on the X axis, and the total sales on the Y axis.  I want to show only countries that are in Region = Europe and I don't want the user to be able to change the Region on this chart.  

Can I do this?

If I do this, can I have a visible filter on the sheet that will allow the user to select specific countries in Europe?

If so, how is all of this done? 

Thanks!
- Barry

hello,

I need to show the null values as 'Others' in a pie chart for different customer_types.

i used the below expression, but its not working.

if(isnull(customer_type),'Others',customer_type)

i also tried to use the relative value for the dimension. I gave it as >=1.0%. This works fine. But there is one customer_type, for which the value is <1.0% i.e.,0.3%. This value is also included in Others. I dont want this to be included in Others. Is there any other way to do this. Please suggest.

Please find the attached screenshot.

Measure used is:

Count( {1<card_fYear={"<=$(vMaxYear)"},card_status={'ACTIVE'}>} distinct customer_id)

the Portion in grey color in pie chart must be shown as Others, but rather it just displays a '-'.