Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation

Hello,

I am beginner at Qlikview. I am good at vba and other coding languages but i dont know how it works in qlikview. in qlikview i have sku list and amount of revenue which is gained from that sku. i want to calculate the # of top SKU's which is equal to %80 of sales


thank you.

11 Replies
Not applicable
Author

I think you could just use the GetAlternativeCount(Fieldname) function.

You could for example display it in a textbox.

If the GetAlternativeCount() function doenst work try one of the other Get.....() Functions, you can find them in the qlikview Reference Manual --> System Functions.

Not applicable
Author

Sir,

I got it until Row section. It writes "1" the rows will be selected but i dont know how you trigger the selection. I did it, and at the next column of rows will be selected, "1" is written but i dont know how can i make them selected. I hope i could express myself. Thank you by the way. If i can do that and then say countselected() then i will be done.