Discussion board where members can get started with Qlik Sense.
I have two measures,
for example Count(Branch), Count(SalesPersons)
I don't have dimension. Based on the measures i have to display that as dimension.
my dimension will be like
No.Of Branches 10
No.Of SalesPerson 150
This is possible by using valuelist & creating inline table. Is there any other solution available..????
Depending on how you display the measures do you really need a dimension?
For example you could but the expression in a text box and concatenate the title
='No.Of Branches '&Count(Branch)
You can use ValueList() to create your dimensions, and in the expression you can refer them to do calculations:
I am also attaching a sample app.
Hope this helps.
You can achieve this scenario using a pivot table,
Please have a look at the attachments.
Hope this Helps you.
use Valuelist in Dimension as Valuelist( 'No.Of Branches' ,'No.Of SalesPerson' )
In Measures: Pick(wildmatch(Valuelist( 'No.Of Branches' ,'No.Of SalesPerson' ),'No.Of Branches','No.Of SalesPerson'),
sum([No.Of Branches]), sum([No.Of SalesPerson]) )
I hope this is helpful.
Try like this
Dimension: ValueList('No.Of Branches' ,'No.Of SalesPerson' )
Expression:If(ValueList('No.Of Branches' ,'No.Of SalesPerson' ) = 'No.Of Branches', Count(Branch), Count(SalesPersons))
Hope this helps you.
Simply add those 2 expression in bar graph and don't add dimension. it will show you the 2 bars and doesn't depend on dimension since there is no dimension.
Use Text in label option to add a label over there.
Without dimension bars won't get displayed, so add an empty dimension (something like ='') or use value list.