Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Excel Data and I need to find two Output fields
1. Count of all the values
2. Count of Missing values.
I tried using the CrossTable approach but the field names are not the right ones. How to achieve this in QlikView? I need to create Total and Missing Fields
My bad can you use below expr for empty values like below
= Sum(Values)
= Count({<Values = {''}>}Values)
Check attached.
Thank you for the quick action Let me check this one.
Hey buddy,
What you need is the Horizontal Calculations. So keep it simple and there is no need to add any Crosstables. Use the 'Range' functions. PFA is the solution.
Thanks
JT
Hi Jayant. Thank you so much. This function is awesome. We never realize how many functions we have and how to use them. Although Cross Table is a bit easier since it runs in the back-end script and you don't need to fill in the field names manually within the function, it's good to know this function exists Really appreciate your help. I just learned something new.
Thanks and Glad you like it:
There are following Range functions you can have a look :
Counter range functions
ClosedRangeCount
ClosedRangeMissingCount
ClosedRangeNullCount
ClosedRangeNumericCount
ClosedRangeTextCount
And Dont worry you can use them all in SCRIPT as well.
If you are happy with the solution then close this thread marking the correct answer.