Hi, 

i would like find a way to define an upper/ower limit manually.

Let the user, point and clic, point by point  to define a line. As far as i looked for, i didn't find any extension for that kind of functionnality.  

Anyone got an hint ?

Hi,

I imported variables from Excel into Qlik Sense Script, but it can't be assigned to a client advisor. How can I do it?

In Script I have following:

Expressions:
LOAD
Variable,
Expression,
Comment
FROM [lib://Mapping/Mastertable_Variabl.xlsx]
(ooxml, embedded labels, table is Tabelle1);

Let vNumberOfRows = NoOfRows('Expressions');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('Variable',vI,'Expression');
Let [$(vVariable_Name)] = Peek('Expression',vI,'Expression');
Next

And the Table is:

The variable import is working, but when i want the variable by client advisor it calculate for each the same value.

Any idea?

Hi all,

I have a set of 2 year's data and i want to calculated a daily price range. I use max(rate)-min(rate) in a table also with other two dimension currency pair and client.  I want the max and min only reflect its daily range when i select a date but calculated a cross all client. An example will be  when i select a client, a date and a currency pair, the max() returns the max number for the day, for the currency pair but across all client. 

I tried Max( total < currencyPair > rate), which gives the correct result as long as i only select date. I want also be able filter the client. Can nay one hlep me with it?

Thanks!

Hello everyone,

This is a glimpse of my dataset:

I want to make a table within my app with set analysis to show what rows are the same for different months, but in a way that always compares current month with previous month, and also current month with a month before previous month. 

Basically I want to see the intersection between months, but since my table is updated monthly, I always need to compare current month with others, and I want to do so without specifically naming every month.

If I need to clarify more, please ask.

Thanks in advance.

Regards,

Milos

Hi,

I have create an app using qlik sense. The source data is excel files and every file represent one month. So I get every month an excel file to load it. All the files have the same structure, so I use the following approach:

Table:
    Load
        A,
        B,
        C,
        D,
FROM [lib://AttachedFiles/Jan2019.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate Load
        A,
        B,
        C,
        D,
FROM [lib://AttachedFiles/Feb2019.xlsx]
(ooxml, embedded labels, table is Sheet1);

.....

How can I dedicate the month and the year while there is no field can be used as date.

I think it can be solve by generating a number field in every file and use it as month:

Table:
    Load

Month,A,B,C,D
1,name,surname,country,city
1,name,surname,country,city
1,name,surname,country,city

FROM [lib://AttachedFiles/Jan2019.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate Load

Month,A,B,C,D
2,name,surname,country,city
2,name,surname,country,city
2,name,surname,country,city

FROM [lib://AttachedFiles/Feb2019.xlsx]
(ooxml, embedded labels, table is Sheet1);

.....

but i don't know how to achieve this in the script while there is too much rows. And how it could be generated automatically every month.

Thanks in advance   

Hello, 

i have some issues. Qlik Sense (QMC and HUB) no longer loads extensions or images + access problems on a lot of apps. 

Errors of this type on many applications and for everyone

How can i resolve this please ?

Found attached the errors

Hi can someone help me to figure out this

= If(Len(Trim(allconvoyear))=0, Null(),count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}allmatric_no))

i dont want to count null value for allconvoyear because in my graph the convoyear null value is showing the null value 9k++

I have the following table:

I have used Rank() in order to rank the number of tickets in  each month

Ex: since service ABC is having the highest no of tickets in Jan, it has rank 1 (Rank in jan). However the same service is in Rank 5 in Feb.. and so on.

I need a formula to calculate the last 2 columns...

If a particular service name is having a rank(<=20) in all the months, ranking counter must show 4 and the column named "latest month of ranking" would be Apr.

(Since that particular service falls under top 20 in all the months and the latest month being Apr)

Similarly, for service name KIJ, it has been in top 20 for 2 out of 4 months (jan and mar), thus the ranking counter must show 2 and the latest month would be Mar.

This calculation must be made dynamic whenever i  obtain the future month's data. i.e.. Next month i would get May data and create a column -- Rank in May.

At this point, the "ranking counter" and "latest month of ranking" must automatically reflect with the new changes.

Is there a feasible solution for this requirement?

Hello, 

I try to connect Qlik sense desktop to an existing database.

I tried by ODBC and OLEDB and I always have the same problem :I can connect to the database, see the Tables names but it doesn't load any value/columns... It stays empty... An idea to help ?

I tried with OLEDB, ODBC 32 bits, ODBC 64 bits, maybe there is a problem with the DNS