Hi,

I'm new to Qlik and I'm trying to generate a table as shown below. Using the Pivot table, I came up with getting near the structure but could not add the Total row for Amount as shown for each unique value in Name. How can I add that?

Hi,

I have an Alternate State on Field "Date" with visualizations that are being affected with the alternate states.

This causes other filters to not affect those visualizations (That are affected with the alternate states).

I know, for example, that i can do this in the set analysis: Country= $::Country, but that will let only the "Country" Field to affect the visualizations.

is there a way for me to let all dimensions (Apart from the Date, Which has Alternate States on it) filters Affect the visualizations that are affected by the alternate states?

Thanks,

Tom.

Hi

I have to obtain latest data using sql query. I have loaded the data using HIVE connector. It has three field year,month,date. I want to find max(year),max(month),max(date) and output the latest partition data. 

Example:

Table1:

Load 

..

..

..

year, 

month,

date;

Temp: 

Load max(year) as maxyear,

max(month) as maxmonth,

max(date) as maxdate;

resident table1;

drop table table1;

SQL select * from HIVE.tablename;

I want to get the latest partition every time. I am not sure how to use the SQL statement and not sure if I am doing the right thing in load statement. I am very much new to qliksense. 

Thanks in advance. 

Hi all,

I have these fields as an example:

Field_a

1

2

3

Field_b_1

4

5

6

Field_b_2

5

6

7

Field_b

Field_b_1

Field_b_2

I want to create Field_c with the following expressions:

Field_c

=Field_a*Field_b_1

=Field_a*Field_b_2

Later I need in chart expression the value of Field_c (pre-defined expression). (by selecting Field_b_1 in Field_b, the related expression in Field_c should be computed).

How can I generate Field_c and how the expression in Field_c can be recignized in chart expression (by selecting Field_b_1 or Field_b_2 from Field_b) ?

Any help please?

Thanks in advance.

All,

I have a simple table.

User              App      User Access last used NA               User Access Last used EMEA

User A          Test          03/21/2020                                                          -

User B         Test A             -                                                                      05/04/2021 

I want to fill the dash with blank. To achieve that I tried using the below expression in the app but did not take the effect.

=if(isnull([User Access Last Used NA]),'',timeStamp([User Access Last Used NA], 'DD/MM/YYYY'))

I tried some thing like this and did not work either.

=if([User Access Last Used]='-','',timeStamp([User Access Last Used], 'DD/MM/YYYY'))

Can some one please take a look and advice?

Thanks

Hi All,

After reloading the section access script, I am getting  the following error, "Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script." 

I already added my details, however, QS is showing same error.

Below is the section access I added:

Section Access;

SECURITY:
LOAD * inline [
ACCESS,           USERID,            RESTRICTION
  USER,      DOMAIN\F12345D,          *
  USER,      INTERNAL\SA_SCHEDULER, *
];

Concatenate(SECURITY)
LOAD
Upper(trim("Access")) as ACCESS,
Upper(trim("UserID")) as USERID,
Upper(trim(Region)) as RESTRICTION
FROM [lib://AttachedFiles/ User List.xlsx]
(ooxml, embedded labels, table is [SECURITY]);

Star is '*';

Section Application;

Thanks

Nakul

[59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed to install MSI package. [59A0:66E0][2021-05-08T20:21:11]e000: Error 0x80070643: Failed to configure per-user MSI package.

Hello guys,

I'm using a bar chart with dates (DASI field) on X axis and the sum of seats offered (TOTS field) per airline on Y axis.

So, my dimensions are: DASI and NCIA, as you can see below:

And my expression is: sum({<DASI=>} aggr(sum({<DASI=>} TOTS), KEYI)),

Where:
DASI is a date field,
TOTS is the total number of seats
KEYI is the key field.

Basically, each fligh has its own Key.

But, my problem is, once I'm summing the total of seats per KEYI and if the airplane took-off at night and landed on the other day, the system is considering two times this KEYI. Because it's a distinct KEYI on day 1 and a distinct KEYI on day 2.

How can I just consider the KEY (KEYI field) if it has not been previously considered?
So, if the airplane took-off in one day and landed on another day, I would like to consider the seats offered just on the first date.

Thanks