Requirement is to create block chart for users / clients who have logged in websites. need to create separate block each in block chart.
- Users logged in using web only
- Users loged in using mobile app only
- Users logged in using tablet only
- Users logged in using web + mobile app
- Users logged in using web + tablet
- Users logged in using 3 Channel
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..
