Welcome to Qlik Community

Hello,

I have an tabel object with multiple dimensions and measures. I have a measure calculated like maxstring(field).
But when I filter on some field it becomes '-' for some rows.
I would like to suppress those rows, but I know that null values can only be suppressed in dimensions, not measures.
So I tried to make an calculated dimension like
If(isnull(maxstring(field)), null, 1) so I can filter with it the null values, but I gen the invalid dimension error.

Any ideas?
Thank you

Hello 
got a dashboard in which there is not plenty of Dimensions created as master items with descriptions and tags
is there a way to list these details (dimension name, description, tags) in a table

Kindly advise @sunny_talwar 

Repeat Caller Logic within 48 hours. (Repeat caller duration is based on callstartdate and prevcallsegstartdate as per the example provided)

Formula: Numerator - Unique Contact , Denominator - Unique + Repeat Contact

From the above example -
In the case of 123 phone number (1-2 row number) - its a repeat contact.
This customer contacted twice within 48 hours based on the first two rows

Now in the numerator - it should be 0
in the denominator - it should be 2

3rd row - again the same customer contacted after 48 hours, it should treat as a new customer
Now numerator - 1 and denominator - 1

In the case of 126 customer phone number - its unique contact
Now numerator - 1
denominator - 1

Total KPI value - Numerator - 0+1+1
Denominator - 2+1+1

Can someone help me how to achieve this in QV scripting?

Thanks

Government agencies are continually looking to unearth greater insights from their mass amounts of data, and this is why those in the public sector are integrating data lakes as part of their IT initiatives. Holding both structured and raw information, data lakes allow agencies, like the Department of Defense (DoD), to better use data as a strategic asset.

Read more.

Hi Community,

When i try configure QVD Import , for Default QVD Mount Point * to QVD mount point then i am getting below error

×Error! "pgui.error.code.LOCALFILE_INVALID_DIRECTORY - Invalid path. Directory path should start with '/usr/local/qdc/sources'"

Also i see "User does not have /qvd-share/NGAPT/4_QVD directory access" so which user access need to check?

Can you please help me if anyone has face same issue during setup.

Thanks,
Akshaye

Greetings!

We recently ran into a situation at a customer site that we can't understand.  The customer is running a single node, on-prem QSE June 2020 SR3 site and its SLK has been applied for quite some time (several months).  Suddenly this week, the Qlik users began getting a pop-up message indicating that "You can not use Qlik Sense because you have no access pass".    We get a support call, review all the usual suspects in the QMC and everything seems fine.  While we are working on the case, one of the customer's developers tries to navigate from the QSE server to an external web site and realizes that there is an Internet navigation problem, he calls his network support people and they fix the problem.  Just after this is done, the Qlik Sense error pop-up ceases to appear and everything goes back to normal.

The customer is working from an internal network and clearly has connectivity to the QSE server.  After investigating we found out that there was an unplanned major event in their data center last week, so we assume that the Internet connectivity was lost at this point in time, but we are not 100% sure.  In any case, if the event last week was really the cause for the lack of connectivity, the time since then is much less than the 60 days in which the license service can supposedly work offline.  So, we have a few questions:

1. Do anyone have any idea of why QSE could have gone through this process with only a few days with lack of Internet connectivity?;
2. Is there another timer for "intermittent" offline scenarios after the SLK is fully in use that we (partners) are not aware of?; and,
3. Is there anything that we could look for in the logs to find out exactly when the license service stopped being able to reach license.qlikcloud.com? 

We just want to understand why the pop-up appeared and then disappeared with less than a week between the two events described.

@Sonja_Bauernfeind, any ideas?

Cheers,

++José

HI,

Can someone explain how and where below is used with the second parameter like below(sum(sales),3,2)

I understand below(sum(sales),3), but what does the next parameter 2 do ?

Hi All,

I have a scenario of calculating a Visit as Compliant based on the Categories (if matching criteria). But i am unable to do a nested sum or overall count on below expression. Can you please guide and help me out.

I will be very thankful to you.

CRITERIA:

Category-6 : 14

Category-13: 10

TRIED EXPRESSION:

if(
sum(aggr(sum({<Parameter={'OSA-1','OSA-2','OSA-3'},Store_Type={'Cosmetics'},Category={'Category-6'}>} Achieved), Storecode,Visit,Category))
>=14,1,0)
+
if(
sum(aggr(sum({<Parameter={'OSA-1','OSA-2','OSA-3'},Store_Type={'Cosmetics'},Category={'Category-13'}>} Achieved), Storecode,Visit,Category))
>=10,1,0)

DATA and RESULT I AM GETTING vs EXPECTED: