Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
minifutboliukas
Contributor
Contributor

How to count %

Hello guys, hope you will help me, im very new user to Qlik sense.

I have a table and new column  where i can set value if my stock have parameters or not.

=if(isnull(ilgis_Xnew) or ilgis_Xnew=0, 'No', 'Yes')

 

after this i need a summary how many unique items have parameters and that % of total is.

i do counting with this

Count({<stock_ind={'1'}>} distinct skn_gaminta)

and the result is

No  59 000

Yes 10 000

Total 69 000

I need one  more column

to get

No 86%

Yes 14%

 

 

Labels (1)
1 Reply
Or
MVP
MVP

Sounds like what you need is:

Count({<stock_ind={'1'}>} distinct skn_gaminta)

/

Count({<stock_ind={'1'}>} total distinct skn_gaminta)