Hi Team,

I would like to see frequency of each value in Filter pane(Qliksense).How it can be possible?

Example: In Qlikview we can see frequency of each value in list box by checking the show frequency option.

Regards,

Masthan

Hi All

My date field as below :-

Month

D/M/YY

I try below , it does not work :-

Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],

Hope some one can advise me.

Paul Yeo

Hi All,

After migration Qliksense server Nov2019 from one machine to another with the same version. 

Facing Access was denied the issue after 6-7 hours of migration.

Follow all the steps which are given on link:-  https://support.qlik.com/articles/000041283

After doing all the steps QMC & Hub both works properly. After 6-7 hours it starts showing the attached error on both HUB & QMC.

Hello,

I have a complex (maybe only for me) situation. The sample data in a straigth table is:

It is kind of self explanatory. entry_date has values of change_date if it is not null or sign_date value if change_date is null. contract_id 4 (and it is no mistake) has been signed and changed on the same day, so it has two entries for 2017-12-30.

On the side there is a calendar created for filtering. If the analyst selects, for example, 2017-12-30 - the table needs to show the most recent entry_date for each contract_id that is not greater than the selection.

So, for the selection of 2017-12-30, the table needs to look like this:

Only one entry per contract needs to be displayed. If the analyst selects 2015-01-06, the table needs to look like this:

This needs to be done in expressions, since it is based on selection. Any help would be appreceated.

Hello everybody,

I'm currently trying to integrate Plotply into Qlik. However, I always get the error message: "Uncaught SyntaxError: Unexpected token '<'".

The Plotply script works outside of Qlik, so I assume that the problem belongs to Qlik himself or my programming skills in Qlik. ;D

This is how I integrated it into Qlik:

define( [
        'jquery',
		'qlik',
		'Plotly'
    ],
    function ( $, qlik, Plotly ) {
        'use strict';

        return {

            paint: function ( $element, layout ) {

				$element.empty();
				
				$(document).ready(function() {
					var s = document.createElement("script");
					s.type = "text/javascript";
					s.charset = 'utf-8';
					s.src="https://cdn.plot.ly/plotly-1.2.0.min.js";

					$("head").append(s);
					
				});
				
//############################Other Stuff
            }
        };
});

That's how I call it (Simple example from the Plotply page: https://plot.ly/javascript/getting-started/😞

TESTER = document.getElementById('tester');
Plotly.plot( TESTER, [{
x: [1, 2, 3, 4, 5],
y: [1, 2, 4, 8, 16] }], {
margin: { t: 0 } } );

After calling "Plotply.plot (TESTER ...);" I get the following error message: "Uncaught ReferenceError: Plotly is not defined". I think that's because there were problems interpreting the script...

Can you detect a mistake? The current version with the link "https://cdn.plot.ly/plotly-latest.min.js" and as local  plotly-latest.min.js doesn't work either.

Thank you very much for your help and have a nice weekend

A456B123

Dear All,

I would like to count how many technicians worked a day
Sick technicians are to be deducted from this figure.

So my formula: Count(Distinct(TECHNIKERNAME))

So far it will calculated correctly.

But how can I deduct the number of technicans where the Job result is "Sick"?

Hi,

I have requirement to create year wise qvd dynamically.

EX:-if Source file:-  Market.xls

In Market file have contain multiple year (Like year field contain 2010 to 2019 )

So i need to create qvd like :- Market_2010_Jan.qvd,...Market_2011.qvd_Jan,....Market_2019_Dec.qvd

Hello Everyone,

I have a problem with an expression today . I think what Iwant to achieve is impossible but.. But maybe someone will have a magical idea 😉 ?

We sell a product  with a base on wich can be added options.

Information are stored in a database in 2 differents tables :

1 stored the SN (serial number of a system - unique indentifier of a system sold) with global options selected by the customer , Attention the customer can begin with Base system with or not options and in the future he can add Options, it will be still 1 line but add info to the SN : simplified exemple :

BASE 1 :

If I want the total of Option 3 in the market : answer is 6

Now I want have the number of this option 3 (or even system it is the same problem), sold per year or month, 

I have an other database , which store every Orders by SN and date.

So every time I have an entry it is a new line, If a customer update his system or add a new options :

Problem :

I joined the 2 tables with Qlik to chart my sales per year or month.

But If I make a chart to display the number of Options 3 or Systems per year for example (or month), The total through the years will be 11 instead of 6 because it will show every orders of Systems with the Option 3 for example. (If I want numbers of Option 1 instead by years, the real total is 3 but if I am charting it by years, it will display a total of 8 (because it will show every orders containing SN with option 1).

The only solution I came up with was to do something like :

To have Options 3 sold in 2012 for example

(Total of Options 3 from year 0 to year 2012) - (Total of Options 3 from 0 to 2011)

But this will give me number but I can't chart it anymore by using standard chart with Date as a dimension... Right ?

I know it is not easy to understand but if somebody has an idea :)...