Hello

I've been looking for days for a solution to get my advanced straight table to work as I wish. The aim of my table is to filter/show only values with a minimum level of sales and a certain variation of sales from one year to another.

I have no difficulty to run all calculations based on user selection (I use variables in my calculations).

Nevertheless, I do not manage to hide rows based on conditions.

Conditions could be : 2017 Sales > 2000 and 2018 Sales > 3000 and variation 2018 vs 2017 is between -10% and 0%.

To make it more simple, let's try to focus on showing only rows where sales variation 2018 vs 2017 is between -10% and 0%.

My sales variation is calculated as follow:

=if (([$(vYearRef1)] > 0 and ([$(vYearRef2)]=0)),
100,
if (([$(vYearRef1)] = 0 and ([$(vYearRef2)]>0)),-1
,([$(vYearRef1)]/[$(vYearRef2)])-1))

vYearRef make reference to column names (2018 and 2017 in my example)

I have tried many different possibilities : do not show null values setting all fields to null if conditions are not fullfiled, set limitations (but I can not put a min and max value), aggr functions in the dimension expression...I'm now giving up and asking for your help..

Do you have any idea how to only show countries (rows) where the variation of sales is calculated between -10 and 0%.

Each year sales is calculated thanks to functions:

pick (Vparts,
pick (vAffichage,
sum({<[D_SALES.autoCalendar.#Year]={$1},[HIERARCHIE]-={"*PIECE*"}>}NET_POSTE),
sum({<[D_SALES.autoCalendar.#Year]={$1},[HIERARCHIE]-={"*PIECE*"}>}QTE_POSTE)
),

pick (vAffichage,
sum({<[D_SALES.autoCalendar.#Year]={$1}>}NET_POSTE),
sum({<[D_SALES.autoCalendar.#Year]={$1}>}QTE_POSTE)


)
)

Each year column calls the above function  (example for 2016):

($(vSalesCalculation($(=$(vCurrentYear)-3)

IThanks for your help

pat

 Hi,

Can any one please suggest which licensing option is best (user based or token based ) using for real time environments with less operational cost for around 100 users.

Thanks in Advance.

Hi, I want to save object as pdf in mashup. 

'As sheet as PDF File' extension I have achieved to save the whole page as PDF but I want object wise PDF.

So could you please guide me how to achieve this.

Thanks, Sumanta

Hi Qlik Community,

I am posting QIB-NLU inquiry here as no thread is found in the drop-down list.

I have tried to connect QIB-NLU with the certificates issued by my QlikSense Server & also tried with SSL-Certificate (issued by Certified Authority) but in both cases i am unable to connect both machines, please note that QIB & QS are installed on same machines.

Below are the logs taken from QIB-NLU-Configuration File:

}
2019-10-18 15:13:52.5062|INFO|Configuration|CreateAgent|Creating new agent for Qlik Insight Bot nlu
2019-10-18 15:13:52.5212|INFO|Configuration|SendRequest|Sending request with following parameter
2019-10-18 15:13:52.5322|INFO|Configuration|SendRequest|Method: Post
2019-10-18 15:13:53.4148|ERROR|Configuration|SendRequest|Error while sending request with following parameter
2019-10-18 15:13:53.4289|ERROR|Configuration|SendRequest|The remote server returned an error: (401) Unauthorized.
2019-10-18 15:13:53.4419|ERROR|Configuration|SendRequest|{
"status": "error",
"message": "NLU configuration failed."
}
2019-10-18 15:13:53.4549|ERROR|Configuration|CreateAgent|Error while creating agent
2019-10-18 15:13:53.4689|ERROR|Configuration|CreateAgent|{
"status": "error",
"message": "NLU configuration failed."
}
2019-10-18 15:13:53.4830|ERROR|Component Configuration|ConfigureNLU|{
"status": "error",
"message": "NLU configuration failed."
}

Hello,

I'm trying to compare multiple versions of sales over a yearly time frame.  For this example its 2019-2024.

in version "XYZ", 2024 was not planned but it was in "ABC".

Then, I did a comparison line item to show the delta between the years and I would like to show the line only comparing the years planned in both.  As you can see, the line shoots up in 2024 and it's not very nice looking.

Any way I could get the delta calculation line to stop at 2023?

Thanks!

Hi everyone,

I have problem with the use of operande ">" with Dates.

Even if I can use it with numerics values, it doesn't work with dates for me.

I want sales after a certain year or between certain years

but :

Sum({$<[Date.autoCalendar.Year]={">2000"}>}SALES)

Or even :

Sum({$<[Date.autoCalendar.Year]={">2000<2019"}>}SALES)

Are not working...

But surprisingly :

Sum({$<[Date.autoCalendar.Year]={"2000"}>}Sales)

Is working and give me sales of year 2000

Also, I think my problem with the comparators "< and >" are only wih dates... I tried with other values that contains figures and it works...but it should work with years as well as it is one of the precise example on the "help" documents no ?

Do you have an idea where the problem can come from ?

Hello all,

I'm working on installing Qlik Sense in a single node environment. I've installed and setup PostgreSQL database on the same server as the server on which I'm installing Qlik Sense. I'm at the very first few set of steps in installation process, particularly on Shared persistence database connection settings window. This one:

Since I already have database set up and configured, I don't want to install it again so I unchecked Install local database check box. Now it's asking me for Database host name.

If the database is installed on the same server as the server that I'm installing Qlik Sense on, should I leave Database host name as localhost or should I change it to actual server name?

Thanks,

Mikhail B.

Good Afternoon community,

I have been digging for this solution for a while and finally I found this knowledge base where is basically the situation that we are facing:

https://support.qlik.com/articles/000056252

The problem is, in this case the application is not authorizing as the article is saying, in the logs I can see that my LDAP server connection is very slow and its not responding in time, forcing the principal name to not be acquire.

But as the article is saying, the application should release the authorization and allow the user to login. This is not happening and the user browser starts to ask for the user the login and pwd. That have bee happening from time to time everyday, its intermittent, after some minutes the user just try again and the SSO works fine. We are using Active Directory here. 

I'm attaching more details. Any ideas? Thanks for the collaboration...

Hi Community,

I am trying unsuccessfully to show in the same row the value corresponding to the same date but from the previous year.

I tried different expressions of set analysis from the community but without success:

= SUM({< [SalesDate] = {$(=AddYears([SalesDate]-1))} >} [Price_ExtRetail])

= SUM({< [SalesDate] = {"$(=AddYears([SalesDate]-1))"} >} [Price_ExtRetail])

If someone can give me some light on this matter I really appreciate it.

Thanks!