Displaying dimension based on measure ??

[Silambarasan1306]

Hi All,

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              

                       Dimension                  Measures

                     No.Of Branches             10

                     No.Of SalesPerson         150

This is possible by using valuelist & creating inline table. Is there any other solution available..????

Thank u.

[harishkumarg]

Yes, it is possible.

Please find the attached QVW for reference.

Regards

Harish

[danansell42]

Hi

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)

Dan

[sinanozdemir]

Hi,

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.

Thanks

[lakshmikandh]

Hi Simbu,

You can achieve this scenario using a pivot table,

Please have a look at the attachments.

Hope this Helps you.

Thanks,

Lakshmikandh

[Silambarasan1306]

Hi All,

Thanks for all your reply,

But i need my result in bar chart.

@

[shraddha_g]

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.

[jagan]

Hi,

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.

Regards,

jagan.

[CELAMBARASAN]

Hi

QlikView

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.

For QlikSense

Without dimension bars won't get displayed, so add an empty dimension (something like ='') or use value list.