For my dashabord, apart from count() function the other functions (Sum, Avg, Max, Min) are not giving any result though I have data. I am using very straight formula (no set expression is being used).
Data source is hive tables (Ref. Hive_Data.png)
Same dashaboard is working correctly with all the results when I am connecting the same data from excel. (Ref. Excel_data.PNG)
It seems very strange to me. Not sure what am I doing wrong.
Or, since count() is working and other aggregation functions that require numeric data are not working, it could be that the 'Total_Count' is not being loaded as number but string.
It may be because data is not properly conected in the data model. For example, filter 'EMMA' and 'First Name' and create filter panes with Valid_Count and Total_Count fields. Check if there is data!
Or, since count() is working and other aggregation functions that require numeric data are not working, it could be that the 'Total_Count' is not being loaded as number but string.
Like @jaibau1993 mentions, there is no connection in your data model. Have you defined keys in your data model? Can you show us a picture of the data model viewer?
Qlik will show the total of values when there is no connection and this is what you are seeing in the table.
Yeah, I didn't notice that as the Hive table was present in different server. When I checked the structure ...these fields were defined as String. I changed it to Int and it is working fine.!
