Welcome to Qlik Community

Hi Everyone,

I have to calculate 3 KPI's in qlik sense.

I have to show Count of resouce Id's.if i Select 20-06-2020 as example. 

1)Need to show count of resource id's who changed the department and came into HR.

     E.g : 101 and 108 are changed from Technical to HR, so need to show count as 2

2) Mainly I need help here :Need to show who left the department HR.-----Count as 2(90 and 95 are changed from HR to TAG)

3)Total count of resource id's belong to HR department.---4

Sample Data:

I have the sample data like below.

TIA

Aj

There are so many great apps on https://demos.qlik.com/qliksense

Some are mashup webpages created by QAP. But some apps just look like an offline Qlik Sense app with full sense experience, e.g.

https://sense-demo.qlik.com/sso/sense/app/f06921c2-70b4-42c3-88c5-40525b050d36

https://sense-demo.qlik.com/sso/sense/app/c5e3a72d-a14c-486c-bc95-3465e6ad4c1a

Even the URL looks like the url of an app on enterprise server at work - <Server name>/sense/app/<App ID>

Basically this method allows anyone online to open the app, see the sheet overview, each sheet, story, etc.

How to make this happen?

Thanks

Hello ,

I am facing very strange issue while storing txt file in qliksense:

I have below connection:-

Now i writing the store syntax like this:-

Store Users into [lib://Site HR (ad_admin.kkishor)/HR Divisions Scorecard/Security/Users_New.txt](txt);

I have entered my connection name as well but still the txt file  is not created at the location. I am not able to understand what i am missing . Can any one please help ?

@Anil_Babu_Samineni @sunny_talwar @Gysbert_Wassenaar @p_verkooijen 

Thanks in advance

Hello community!

I am new in Qlik and I alrdy have a lot of questions! But at this moment I got stuck with setting up pivot table. I cannt find how could I sort my pivot table by measures. There is only option to sort it by dimensions. Is there any option to have it sorted by measures?

I use 6 rows and 2 measures and I need to sort it by one measure. It is mandatory for me to analyse data.

I have found a few questions regarding to this, but unanswered or outdated for old version of Qlik.

Thank you very much!

..DB

Hello:

   Need your help. I have initial QVD file format as below shows.

But I would like to get the output QVD file that only show the latest 'D Time' by 'Pdn name'.

Expected result:

Thanks your help.....

Hello Team,

We are noticing considerable Replicate performance degradation in Replication loads when switching from CSV file format to JSON.

Curious to know why and if someone else has same experience. Thank you!

Hi,

I am using 'Page' in NPrinting power point report. I am trying to restrict the value in the field used in the page.

Ex: I have 3 slides. first 2 slide has common KPIs & Chart. From 3rd slide i am using 'page' feature based on year. Year field has data from 2005 to 2020. I need to create page for all the year except 2020.
When i try to use it in a filter it is restricting the data in the first 2 slide too. Is there a way i can use the filter in page?

Thanks,

Pooja

Hello All,

I'm facing issue with levels in the Nprinting. I have created 2 variables from field called category and vCategory1 first selected value of category ans vcategory2 is second selection of category. In the nprinting i created 2 objects one for each variable. I applied the level on a field called scenario. For example i have selected category1 and category2. for the category1 i have 3 associated scenarios and for category2 i have 2 associated scenarios. When i generate the report the 3rd value of the associated scenario is coming under the category2  where the category2 has only 2 scenarios which the 3rd value of the scenario is coming under the category1 as blank object. Please can someone let me know how to fix this?

Thanks,

Anil

I would like to disable the ability for the qlik sense hub to be selected as a report destination.  I don't want Hub to show up in the destination tab at all on the publish task.  Can I do that?

Hola,

Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'..

• SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'.,Error Initializing endpoint. Failed to load 'SQL Server Native Client 11.0' Cannot load <sqlncli11.dll, >: The operation completed successfully. Cannot load <sqlncli11.dll>: The specified module could not be found.

We have ensured the SQL Server Native Client 11.0 is installed from here https://www.microsoft.com/en-sg/download/details.aspx?id=36434

We can see the sqlncli11.dll file in the C:\Windows\WinSxS\amd64... folder.

Anybody know how to solve this error please?