Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%
Sounds like what you need is:
Count({<stock_ind={'1'}>} distinct skn_gaminta)
/
Count({<stock_ind={'1'}>} total distinct skn_gaminta)