Discussion Board for collaboration on QlikView Scripting.
I have a scenario unable to do this scenario. The requirement is client has source data looks in attachments here .
If client writing Query on the database like below :-
( RS_DATE_ID=0 OR RS_DATE_ID>20151115)
KEY_FIELD = (SELECT MAX(KEY_FIELD)FROM FACT_STF_DEMOGRPHCS WHERE staff_id = s2.staff_id)
GROUP BY EMPLOYMNT_TYPE_ID ;
Client able to get result like below:
Staff ewmployment type count(Staff_id)
Asper qlickview expresion i have written code as below:
DISTINCT [(h)Staff ID])
Result i am getting is
can some one help to fix this issue. my gmail id is email@example.com, my contact number in watsup is +601139329865. Thanks in advance - Chala