Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Requirement is to create block chart for users / clients who have logged in websites. need to create separate block each in block chart.
fields are channel which is contained Web,Net mobile & net tablet
Field deviceType is containing mobile,desktop, tablet
Field browserName is containing different browsers like chrome,Firefox etc.
fields are visited, loginid for measures.
Could you please suggest to create different block in block chart as per above requirement.
I have tried to create dimension by using below formula but it's not working
Web+Tablet:
=aggr(count(channel='Web' and deviceType='Mobile'),distinct loginId)
//=aggr(count(distinct loginId),channel='Web' and deviceType='Mobile')
//=if((channel='Web' and deviceType='Mobile'),count(distinct loginId)) showing invalid dimension by using this formula
//=aggr(count({<deviceType={"Tablet"},deviceType={'Mobile'}>}), distinct loginId)
//=Aggr(count(if(channel='Web' and deviceType='Mobile')),loginId)
//=if((channel='Web' and deviceType='Mobile'),count(distinct loginId))
//=if(channel='Web' and deviceType='Tablet','Web'or 'Tablet','')
Web:
=aggr(count(distinct loginId),channel='Web')
//=Aggr(count(if(channel='Web')),loginId)
//=If( channel='Web',count(distinct loginId))
//=Aggr(If( channel='Web'),count(distinct loginId))
//=if(channel='Web',count(lofinId),'')
Help me to create dimension in Qliksense which I can use in block chart and I will get different block for web+Tablet,Web+Mobile, Web etc..
Any suggestion or guidance which will help to resolve it or designed a block chart.