Welcome to Qlik Community

Bonjour

sur un graphe je voudrai figer des autres critères comme la raison: retard prod, le secteur qui s'appelle Sticky et Mixing et j'aimerai compter le nombre de raison

voici ce que j'ai écrit mais cela ne me prend que le critère prod 

= count ({$ <Reason = {'retard prod'}> + 1 <secteur = {'Sticky'}> + 1 <secteur = {'Mixing'}>} [Reason])

est ce que quelqu'un aurait la solution svp?

Hi All,

I have data like Year, Month, Incremental and Sales data is there.

Years like 2018,2019,2020 and 2021 and every years having months data and incremental field is having Yes, No .

Current year is 2020 and incremental data is having Yes, No.

I want to see the data like if Incremental is Yes or No or Yes/No in text box with current year and same thing like i want to see the Sum of sales also.
for example 2020 is having Incremental is having Yes and No then i want to see 2020 Yes/No in text box.
if incremental values is having all months yes then 2020 Yes.

I want to change dynamically  I tried below code.

'2020'& if(ONLY({<Incremental={"Yes"}>} Incremental)='Yes' ,'Yes', if(ONLY({<Incremental={"No"}>} Incremental)='No', 'Y/N')).

But some it is showing either Yes or No. but current i am having Incremental data is yes and No then i want to see Yes/No .

Please suggest me how to achieve this scenario.
Please see the below example for your reference.
 

Thanks & Regards,

Lakshman

Please help on to separate and create Q1 - 2020 from Submissions of Q1 2020 using subfield

Field name = Quarter

Quarter =Submissions of Q1 2020,Submissions of Q2 2020,Submissions of Q3 2020

Requirement =Q1 - 2020,Q2 - 2020,Q3 - 2020

Hello, first of all I want to apologies for my English, didn't practiced for a long time, but I will try to explain.

I need to make a graph which represents correlation between price of product and different types of Inflation on same graph. The issue is, Qlik Sense doesn't want to connect some points to make a graph, leaving just some points.  I've tried to switch of "include null values", but it connects only few points, not all. My assumptions about this problem:

1. It seems that Qlik Sense thinks, that there missed information and don't know how to fill gaps.

2. There also might be a problem with the format. I mean that I have results for product price weekly, while inflation rate counts monthly. However, my results represented in DD.MM.YYYY form, like I have results for price for 01.01.2020, 07.01.2020, 15.01.2020 and so on, while inflation rate represented by the first day of each month. Like this:

and the second table

So, it looks like this format some how breaks the logic of Qlik Sense and it starts to thinks that there are some missing data. This assumption is supported by the last three points of Inflation rate, last three points are connected on all three inflation rate graphs, where I don't have any data for product price. 

So, my question is, is there a way I can fix it? Thank you in advance

Hello everyone,

Basically what i want to do about this data set is the following one

If the sameID appears in the previous year and month  with value >0 and appear also in current year with the previous month as well with value > 0 then it gets '1' in the column permanent staff.

I would like to do it in the script just to have a brand new column permanent staff but i don't know how i could do that ?

In my script it is this 

// LIB CONNECT TO 'BO_DATABASE';

// LOAD YEAR,
// MONTH,
// ID,
// Value,
// if(ID = Previous(ID) and ANNEE = Previous(ANNEE)+1
// and MONTH = Previous(MONTH) and Value >0 and Previous(Value)>0, 1, 0) as PermanentStaff;

// [DATA_TABLE]:
// SELECT "YEAR",
// "MONTH",
// "ID",
// "Value"
// FROM SAP_BO_DATABASE;

// // UNTITITLE:
// // LOAD*,
// // if(ID = Previous(ID) and YEAR = Previous(YEAR)+1
// // and MONTH = Previous(MONTH) and Value >0 and Previous(Value)>0, 1, 0) as PermanentStaff
// // Resident [DATA_TABLE];
// // Drop Table [DATA_TABLE];

But i get PermanentStaff field with zero value everytime.

Where i sample small data like this,

Temp:
Load * Inline
[
ID, Year, Month, Value
180, 2019, 1, 55
181, 2019, 2, 0
182, 2019, 3, 65
183, 2019, 4, 0
184, 2019, 5, 65
180, 2020, 1, 58
181, 2020, 2, 87
182, 2020, 3, 47
183, 2020, 4, 88
184, 2020, 5, 89
];

I get the field "permanent staff" right but it doesn't come from a SAP BO Database.

ANyone could help me.

Hi All,,

I have a requirement . i have written one expression 

sum(actuals) and the result gives me in a number. 

but i have to convert that number into days. 

if FTE i calculated as Sum({<Metric _Name = {'FTE'}>}Actuals) i need to get the result in days. 

REgards

srujana

Hello, everyone.

I'd like to ask for an answer from anyone.

I want to reload 1 app 3 times every day at 10, 10:30 and 10:50.

So I made up 3 triggers by setting 1 task as Daily.

I wonder if this is the right way.

Hi,

I have a web portal (in Angular) where I am opening QS hub in a hidden iframe so the user gets authenticated that way (not the perfect way). this page has a link that when clicked, opens another page that displays list of Qlik apps user has access to. I am calling engine APIs to get list of apps etc. i recently upgraded to June 2019 version of QS.

On and off, some of the users are having issues where session count is going above 5. i can see the errors in repository logs. I can also see the error in chrome console saying QS 400 error, as the hub cannot open in iframe. Also, we asked users to use Chrome all the time, but after this error, they switched to firefox and it works there for some reason !! why it works when it's above 5 sessions?

Session inactivity timeout : 30 mts, and using SAML auth. (ExcelUDC) 

what is the solution for this ? how can i kill those sessions ? or should i go for an actual authentication method instead of opening QS in iframe like this? I do not know how/which authentication api to use with engine APIs.

please advise. 

thanks.

Hi Everyone,

I have a requirement in Qliksense to select a value in a filter based on a selection from another filter. ( Similar to 'select in field'  - field event triggers in Qlikview)

My table is designed as following. 

Requirement :

1. Defined value: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have 'All' selected in 'Column 2'

2. Min String: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have the min string selected 'Sub Product 1a' selected in 'Column 2'

Could you share your thoughts 

Thank you.