This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am having the following scenario as per my requirement (Move "Distinct Count " calculation to script level)
Note : Calculate Distinct Transactions in Script level
In UI Level : Count(Distinct TransactionsID) = 5,
But Script level calculated field : Count(Dist_TransactionsID) = 7
Here i am attaching the application, excel file..
How we can sort out this issue ,......any help ?
Hi Jagan Mohan Rao Appala,
Thanks for your reply...
Here I want to calculate Count(Distinct TransactionsID) in Script level (I want to use this field in UI Level)
1 ) For counting Distinct Transactions it will take long time (That's why i want to move this calculation to script level)
2) I want to join / Concatenate this field to Main table
Any suggestions ?
(ooxml, embedded labels, table is Sheet1);
Count(Distinct TransactionsID) as Dist_TransactionsID Resident Test Group by TransactionsID;
LOAD * inline [
TransactionsID, ProductID, Pname
1, 100, a
2, 101, b
3, 102, c
4, 103, d
5, 104, e
2, 105, f
3, 106, g
Load Count(Distinct TransactionsID) as count_transaction Resident Temp;
It is giving count 5
Try like this
1 as TransCount
Now use Sum(TransCount) in frontend.
Hope this helps you.
View solution in original post
try like this?
autonumber(TransactionsID) as Count,
Now use $(VCount) at UI.
Hope this will help!!
Hi Jagan Mohan Rao,
This logic is working fine.
Thank you very much.....
But i am using Count(TransCount) instead of Sum(TransCount) ......Now also i am getting the same results.
Note : Can i use Count() instead of SUM()
Try and See
it should work!!
dont Use Distinct with Count
Maybe this will suit you?
Count(DISTINCT TransactionsID) as TransCount
Applymap ('Map_Distinct', TransactionsID) as TransCount
DROP TABLE Temp;
Ok. Both are same, since there is 1 in all the records.