How to count %

minifutboliukas — Tue, 27 Jun 2023 12:20:12 GMT

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%

Re: How to count %

Or — Tue, 27 Jun 2023 12:53:02 GMT

Sounds like what you need is:

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

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