Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
silambarasan130
Contributor III

Displaying dimension based on measure ??

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.

8 Replies
harishkumarg
Contributor III

Re: Displaying dimension based on measure ??

Yes, it is possible.

Please find the attached QVW for reference.

Regards

Harish

danansell42
Contributor III

Re: Displaying dimension based on measure ??

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
Valued Contributor III

Re: Displaying dimension based on measure ??

Hi,

You can use ValueList() to create your dimensions, and in the expression you can refer them to do calculations:

Capture.PNG

Capture.PNG

I am also attaching a sample app.

Hope this helps.

Thanks

lakshmikandh
Valued Contributor II

Re: Displaying dimension based on measure ??

Hi Simbu,

You can achieve this scenario using a pivot table,

Please have a look at the attachments.

Hope this Helps you.

Thanks,

Lakshmikandh

silambarasan130
Contributor III

Re: Displaying dimension based on measure ??

Hi All,

Thanks for all your reply,

But i need my result in bar chart.

@Capture.PNG

shraddha_g
Honored Contributor III

Re: Displaying dimension based on measure ??

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.

MVP & Luminary
MVP & Luminary

Re: Displaying dimension based on measure ??

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.

Re: Displaying dimension based on measure ??

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.