Welcome to Qlik Community

Hi,

I have the following tables:

[CAMPOCHECK]:
Load
[IDCAMPOCHECK],
[IDPROPRIEDADEUNICA] 
FROM TABLE X;

//Use previous and peek to get the previous IDCAMPOCHECK for each record.
[IDBEFORE]:
Load
[IDCAMPOCHECK],
[IDPROPRIEDADEUNICA],
If([IDPROPRIEDADEUNICA] = Previous([IDPROPRIEDADEUNICA]),Peek('IDCAMPOCHECK'), Null()) as [IDCAMPOCHECKBEFORE]
Resident [CAMPOCHECK]
ORDER BY [IDPROPRIEDADEUNICA],[IDCAMPOCHECK];

//DETAILS
[CAMPOCHECKDETAIL]:
Load
[IDCAMPOCHECKITEM],
[IDCAMPOCHECK],
[VALUE]
FROM TABLE Y;

What I need to achieve is an expression that show the previous COUNT of [IDCAMPOCHEKITEM] for each [IDCAMPOCHECK] based on [IDCAMPOCHECKBEFORE] in a table like this:

previous count

OBS: can't use above or bellow in this case. 

Thank you,
Henrique

Hi,

We need to implement a SAN storage for our PROD so that another server can take over if it is down.

We want both the servers to access the same data share.

Is having the data share on a SAN the best option?

DID anyone implement SAN for qlik sense? Could you please tell me the best approach for this?

Hi. I need to publish an application that contains user data. For the access level I need that:

• If the user who enters is one on which the application contains data, bring the "User" field that is available in the app filtered by that user (just the filter applied,  does not filter the model data)For example, if i'm the user Arregui, 

  When I enter the application, the "User" filter should be applied, but it should allow me to modify it and see all the data of the model

• If the user who enters is NOT in the list of users in the "User" field available in the app, do not apply this filter

I hope you can help me. Thank you very much

@sguerra2 

Good Morning

I'm facing a recurent problem, almost once or twice a day my qlikview server restarts by itself.

I noticed many error messages for these restarts but the most reccurent one of them is this

Internal inconsistency, general exception in UV event loop

and it's really become an annoying problem since i'm dealing with very large applications (3 applications > 1 0GO) and loading them back to the take a lot of time.
Any suggestions why this happens?

TL;dr:  when I get to the window in OpenInServer where I've connected to the server, I get no applications to choose from, and therefore cannot lease a license.  Has anyone seen this/gotten around it?

This is a new server box, hoping to replace an old buggy one with a fresh install.  I've gotten server to work, run jobs, publish to a webserver, however, I will need to use Desktop to edit a few qvws, and I haven't been able to license it.  I have been on the phone with support, they've confirmed the LEF shows there are license to be leased, and we poked around but found no issues in server or desktop installs, and the correct port is open.  My netops guy has peeked at the security, and doesn't see anything different from my actual production server.

Any ideas?

Hi all,

I have three fields in my script which are numbers. I've confirmed this by doing "isnum()" on each of the fields. They are the 3 columns on the right in this screenshot. However, in my script i am creating a new field called test by doing this: BPtest&MRNtest&datetest as test.

However, there are some results that are no longer considered numbers. If I do num(BPtest&MRNtest&datetest) as test in my script, those instances do not generate any number and are null. Any ideas why if the subparts are numbers why the whole isn't? And any ideas how to solve this?

Hello Everyone!
I need to calculate the total working days of a group of sales reps.
Everyone has the same calendar, but different starting dates (someone started to work after the 1st of January).

In order to calculate working days for a single person that I chose inside my filters, I simply use the following formula:
NetWorkDays (FirstSortedValue({1<year = {'2020'}, rep_name=p(rep_name)>} distinct date, date), today())

This works perfectly for a single rep because it counts since its first working day until today.
My question is: How can I calculate the exact amount of days if I choose more than one rep?

Using:
NetWorkDays (FirstSortedValue({1<year = {'2020'}, rep_name=p(rep_name)>} distinct date, date), today()) * (Count(distinct rep_name))
is wrong because the formula picks the rep with maximum number of days and multiplies them for the number of reps that I choose.
E.G. REP 1 = 30 days; REP 2 = 100 days
this formula returns 200 days instead of 130.

Can anyone help me?
Thanks a lot in advance

All the best!