Welcome to Qlik Community

I need to load only rows which fall into the top 4 values in a field

Risks:

So for the above table, I only need to load RiskID 1234, 1236, 1237, 1239, 1240 as the scores fall into the top 4 for the field

|Regards

I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression.

I have a field Amount that I would like to do a YTD sum, with dates ranging from 01/2021 to 12/2021 called FinPeriod. I've been scratching my head all afternoon trying to come up with the expression and it's just not coming together, could someone please point me in the right direction?

Cheers

Hi Qlik,

I've below two columns in my Dimension value which needs to be format to 00.0% format. 

Ex: 23.1%  (Need one decimal with %).

My original value is 

Any help would be highly appreciated. thanks!

I want to automate Qlik Sense Engine Logging to Warning Level by using a script. I found some related documentations here:

https://community.qlik.com/t5/Knowledge/How-to-enable-Qlik-Sense-QIX-performance-logging-and-use-the/ta-p/1711405

https://community.qlik.com/t5/Knowledge/How-to-enable-QlikView-QIX-performance-logging/ta-p/1716038

https://community.qlik.com/t5/Knowledge/How-to-enable-Qlik-Sense-Desktop-debug-level-logging/ta-p/1798988

Following the above guides, I put the following lines in C:\ProgramData\Qlik\Sense\Engine\Settings.ini

[Settings 7]
SystemLogVerbosity=2
WarningProcessTimeMs=30000
ErrorProcessTimeMs=60000
WarningPeakMemory= 1073741824
ErrorPeakMemory= 2147483648

But it does not work even after I restart Proxy service and/or engine service. Is there some way I can automate this configuration? Doing manually using GUI is not an option!

Hii Guys,

I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

Can help me this anyone please.

Thanks in advance.

Regards,

Subba

Hi All,

Can some help me with below scenario..

I have 2 tables 

1. Employ table with employ no, country and date(date when he was present in that country).

  2. Insider table with employ no, incident number(issues he worked on) and incident_created_date(when that issue was raised).

Now i want to join both the tables and get Country field in Insider table. 

Based on Incident_Created_date <= Emp_Start_Date

i.e.  for Incident_Created_date <= 17/05/2008 Country should be UK

         Incident_Created_date <= 04/02/2009 Country should be US

        Incident_Created_date <= 09/07/2010 Country should be AUS

Thanks in Advance,

Hii guys,

I am new in Qlik senses.

I have a bar chart, dimension is month,I want show the lines in quarter wise.

Example:  Q1 Jan,Feb, March after line ,next bars Q2 April, May, Jun, after line,how to implement this line in quarter wise.

Plese help me anyone.

Thanks in advance 🙏

Regards,

Subba

Hi Team, 

               I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

Tasks : Need to show QVuser name in NPrinting. 

Please refer below my Steps(but i am not getting what i am expected)

1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

2. Value is showing as Prepared By: Sakthivel. Selvaraja 

3. Taking this variable in Nprinting Variable. 

4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

Will anyone help me to resolve this . It is very urgent

Thanks and Regards, 

Sakthivel.S