Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there.
I'm recently upping my game with Qlik Sense.
Qlik is integrated with a software platform I support. Both administrative users and client users work in the platform, and Qlik captures data for both. I've been working to configure my charts and tables to restrict data to only the client users. Those users have usernames with a "gol." prefix, making it easy to programmatically identify them.
I've been able to accomplish this with tables and charts, but not the KPI (or the Gauge).
Here's what worked in a pie chart:
=If([User Name] like 'gol*', [Type of Work])
Here's what I tried in the KPI (and Gauge Chart), but it's not working:
=If([User Name] like 'gol*', Sum([Working Minutes])/60)
All I get is a dash.
Any thoughts?
Thanks!
Hi,
May be try this..
Sum({<[User Name]={"gol*"}>}[Working Minutes])/60)