Welcome to Qlik Community

Hola amigos, tengo 

y me gustaría tener la tabla con el siguiente resultado 

No puedo usar Autonumber (RowNo (), porque se tarda demasiado en procesar 

Hi All,

I need to split the Start Date Time and End Date Time with the Field value.

In the Excel, I want to add Start Date Time Field which is not equal to "0" in  FAULT_NUMBER whereas End Date Time Field which is equal to "0" in FAULT_NUMBER.

Output should be like this below screenshot.

Kindly help me out. Attached the file for your ref. @MayilVahanan   @sunny_talwar 

Thanks in advance.

Regards,

Dinesh Kumar Mani.

Hello! 

I'am using Qlik sense and sankey chart. 

The chart I use expresses too much data, so the readability of the information is very low.

Therefore, I want to use the function used in other charts, but I haven't found a way to use it in the Sankey chart.

Using the GetSelectedcount function, I want to activate the Sankey chart only when data that satisfies the condition is selected.

For example, if you choose one year and one country, show the Sankey chart, and I hope that it will not be activated before then.

Could you help me to solve this problem?

Thank you in advance. 

We have two applications that have been in production for years.  This week users noticed that when they try to open the app they given an error that states 'This page isn't working  <access point path> didn't send any data  ERR_EMPTY_RESPONSE'.    The apps are reloading with no problem from the QMC and we can open them without error on the server directly.   Out of hundreds of apps, these two appear to be the only ones affected. One of them is a binary load off the other, so it makes sense that they are linked.  We have tried to restore backup copies from a couple of weeks ago, but those also show the same issues on the Access Point.  We have an additional load balancer on top of the Qlik load balancer to help direct traffic. The only thing that has changed is that users now go to https instead of http and are redirected. We have not changed to https within QV yet.  Any ideas or help would be very appreciated!!

Hello. I'm having an issue with my expression. I'm trying to count any time that the status changes and the status type is either one of these status types. I don't know what I'm doing wrong here, says I'm missing a ) somewhere? Thanks for the help.

COUNT(DISTINCT if(StatusChanges > 0 AND (SP_StatusType = 'ONSITE' , OR SP_StatusType = 'TRIAGE', OR SP_StatusType = 'REPAIR IN PROGRESS', OR SP_StatusType ='LEAVING SITE',
OR SP_StatusType = 'PRODUCT SHIPPED'),SP_RFACallNumber))

/

Count(DISTINCT SP_RFACallNumber)

I have retired the QVF version of my popular Qlik Sense Document Analyzer tool, previously distributed on QlikCookbook.com.  The QVF QSDA has been replaced by the new QSDA Pro, which provides much more function and addresses the shortcomings and installation issues of the QVF version. 

QSDA Pro includes a free tier with some limits on features and app size.  Full featured subscriptions are available at  very reasonable prices.  Give it a try. 

The QlikView version of Document Analyzer is still available on QlikViewCookbook.com. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com