I have date field " Expiration Date"

I want to show the Expiring Tickets counts and its Value in a Combo Chart for past four months and coming eight months

Fields :

Ticket ID

Value

Expiration Date

Hello together,

For some time now it has been possible to use the formats qvf and qvw within QV.

Unfortunately, I have not yet been able to identify any differences or what advantage the new format is supposed to have within QlikView.

Does anyone have any advice?

Thank you and greetings

Hi Team, 

I installed Qlik sense using AWS marketplace :

https://aws.amazon.com/marketplace/seller-profile?id=ba4c05a7-e7ff-462b-a4d6-99d3f6e77d1f

After the installation, all the services are up and running but I am not able to hit :

http://localhost/qmc

Can you please help here?

Thanks,

Anmol

Bonjour, 

je voudrais comparer tous les champs existant dans deux QVD, sachant que les deux QVD contenants les mêmes champs mais pas toujours les mêmes valeurs.

J'ai essayé avec NOT MATCH mais ça prend beaucoup du temps. 

Est-ce que vous avez une autre solution pour comparer les champs entre les QVD et afficher seulement les lignes différentes. 

Merci d'avance pour votre aide 

while connecting the DB, below error getting. Kindly advise

OleDb error

Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80040E4E. ErrorSource: OraOLEDB, ErrorMsg: The system cannot find message text for message number 0x80040e4e in the message file for OraOLEDB.

CONNECT TO ***

I want to create a report to analyse worked hours compared to an employee’s assigned roster per day. 

Therefore I need to create a table with the amount of hours per date according to the assigned roster

I have the following tables:

ROSTERSETTINGS

Employee_id

Roster_id

Startdate_roster

Enddate_roster

ROSTERHOURS

Roster_id

Roster_name

Roster_days

Roster_day_sequencenumber

Roster_hours

ROSTERSETTINGS EXAMPLE:

ROSTERHOURS EXAMPLE:

The employee started on 1-12-2022, this is the 4th day of the assigned roster, therefore the “startday” of the ROSTERSETTINGS record is “4”.

The table I want to create is the following:

Many thanks in advance for your help!

I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values ​​- Number of open calls and number of closed calls.

I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values ​​- Number of open calls and number of closed calls.

The number of open calls is correct. The number of calls closed is being divided between Sep, Oct and Nov, and it would be necessary to count everything in November, adding the 3 the result is correct, but it would need to count everything in November.

Here are the parameters used to build the graph:

Dimension: Month Opening

Measure - Open calls: Count({$<Status2 = {'New', 'Processing','Pending','Concluded','Resolved'}, SEMANA_FECHAMENTO=,Dt_Closing=, YEAR_CLOSING=, MONTH_CLOSING=, DAY_CLOSING>} Status2 ) -IT'S OK

Measure - tickets closed: Count({$<Status2 = {'Concluded'}, SEMANA_ABERTURA=,Dt_Abertura=, ANO_ABERTURA=, MES_ABERTURA=, DIA_ABERTURA>} Status2) - WRONG

Analyzing the data in table format, I identified that there are calls that were opened between Sep, Oct and Nov and that were closed only in November, but since I am using the filter Month closing = November it should be adding everything for the closing month.

Hi all,

I wanted to check if there is a chart object available in Qliksense that let's us create a data lineage or data semantic layer display, letting us display the flow of data in the underlying source database?

Say if we are getting data from 4 tables and merging to one final table in source database, i want to create a data semantics chart depicting the same and if some data is not available in one of the tables, highlight that semantic connection in red and etc,

Regards,

Darpan

Hi All,

I have 4 measure calculations

i need to divided by column(3) expression divide by column(2) to calculate.

need to display the values based on range.range values in script i stored in variable and using in table.

set vRangeTest = '<= $5M',
'> $5M and <= $10M',
'> $10M and <= $15M',
'> $15M and <= $20M';

i need to get column(3) total value divide by column(2) total value in Rate total

locationpremimun/TIv

i dont want sum for Rate totals

Expected resulst:0.0158699