Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a Straight table which has multiple rows of data?
I want to count the number of rows and shown it in another KPI ?
Please help me do it in Qliksense .
Thanks,
Nitesh
May be use one of the expression from your table or use your first dimension if you have not used set analysis in your expression.
May be like this
Count(DISTINCT Dimension1)
or
Count(Aggr(YourExpression, YourDimensions))
May be use one of the expression from your table or use your first dimension if you have not used set analysis in your expression.
May be like this
Count(DISTINCT Dimension1)
or
Count(Aggr(YourExpression, YourDimensions))
Can you use the RowNo() function in your KPI?
Thanks Mark and Sunny.
Let me explain you my situation .
The table which I have created has close to 70 fields.
I have a primary key and due to other dimensions it is getting duplicated in the table and that is acceptable.
I am not sure how many times each if gets duplicated so when I export the excel the number of rows vary each time .
I want to show the number of rows in a KPI in the sheet. So that before exporting they should know the number of rows they can expect in the excel.
You marked my response as correct, is the issue really resolved are you still looking for help here?
I am still looking for the solution.
Thanks
Would you be able to provide a sample of your application so that we can see what you have and help you in getting what you want
Please let me know if you are not able to understand
May be like this:
Count(DISTINCT Country&city)