お世話になっております。

ロードスクリプトで、以下2つのテーブルを読み、「受講可能月」が軸のピボットテーブルを作成しました。

ーー

table1: ID、受講可能月、月間受講回数

table2: ID、契約日、解約日

ーー

受講可能月は、契約日から解約日までの月をすべて含んでいます。

ここで、軸の「受講可能月」と「契約月（Yearmonth）」が同じ人で、当月受講した人（つまり、契約した月に受講した人の数）をカウントしたく、どのように作成すればよろしいでしょうか。

また、同様に、軸の当月契約当月受講した人が、その月に何回受講したか（月間受講回数）も同ピボに表示させたいと考えています。

よろしくお願いいたします。

I want to create a bar chart with one dimension - Product and two measures - Target Vs Actual, where the color for Target bar is Grey (i.e.fixed ), but the color of Actuals must be red if actuals > target , else it has to be blue as shown in the  screenshot here. Does anyone have any idea to achieve this in Qlik sense bar chart ?  Thanks!

Regards,

Sankar

Hello,

I am new to Qlik Sense.  I'd appreciate it if anyone could let me know how to write a dynamic headcount measure in Qlik Sense.  I was able to do it using the employee database with the information of hiring date and leaving date and was able to obtain the headcount at any point in time with the disconnected table using Power BI; and I tried to recreate the same headcount measure in Qlik Sense, but I have been unsuccessful so far.  I'd appreciate it if anyone could share with me a standard headcount measure which is able to produce dynamic calculation at any point in time from the calendar table.  (I am not interested in inflexible one where I have to indicate in the loaded data if the person is employed at one point in time which I sometimes see in an headcount dashboard example, as this will not be able to generate dynamic result based on the selected point in time).  Thanks a lot for your help.  

Hello everyone,

I am new to Qliksense and need to develop a cross table for almost 18 output files.

I could create for 1 file but unable to do so for all the files.

Can someone please tell me how to do that?

I need the Date, cellname and cellvalue as the cross table columns.

I have attached a sample output file for reference.

How can i create a cross table for multiple such files.

Any help would be greatly appreciated.

Thank you

Regards,

Pankhudri

hi guys,

I have created a  line chart in qliksense. but I'm not getting how to write the  percentages of measures marked just like below:

for me it's coming something like this

Can someone please guide me with this?

Thanks

Hello Everyone 

I am trying to Load Data from https://www.baaa-acro.com/crash-archives but i keep getting an unkown error.  With this code i got only 260 lines fetched 

for i=1 to 1375

let vPage= 'https://www.baaa-acro.com/crash-archives' & if($(i)>1,$(i),'') & '.htm';

LOAD
//Image,
"Date",
Operator,
"A/C Type",
Location,
Fatalities,
Registration
//F8
FROM [lib://Aviation-Crashes]
(html, utf8, embedded labels, table is @1; //filters(

next

I then tried this code and only got to 1305 lines. 

FOR vsCounter = 1 TO 1375

LET vsPage = If($(vsCounter) = 1, 20, 27488 + $(vsCounter) - 1);

LET vsURL = 'https://www.baaa-acro.com/crash-archives' & '$(vsPage)' & '.htm';

SET ErrorMode = 0;

LOAD

@2 AS [Date],

@3 AS [Operator],

@4 AS ["A/C Type"],

@5 AS [Location],

@6 AS [Fatalities],

@7 AS Registration

FROM [lib://Aviation-Crashes]
(html, utf8, no labels, table is @1);

// WHERE Recno() > 4;

SET ErrorMode = 1;

NEXT

 I am not sure what the error is, if someone, anyone can help me please.

After reloading the app from Data Manager, the splash screen says in Portuguese "Your data loading resulted in errors" but when reloading same app on English interface it says "Your data was successfully loaded"

I think there is a translation error on the screen so I always have to say to my clients to ignore it.

I found this issue on version Feb/2021 for Client Managed and Cloud version as well.

Client Managed (pt-br)

Cloud (pt-br)

Client Managed (English)

Cloud (English)

Hope this could be fixed soon !

Pablo