Migrating Bar Chart from Qv to Qs

[kicchu465]

Hi All,

I have a requirement to convert a Bar chart from Qlik view to Sense.

The below are the measures being used in Qlik view.

There are 4 measures being used in Qlik view, Out of 4 measure only for 3 measures the bars are being displayed. The Last measure i.e Rank is shown on Y- Axis along with dimension with out the bars.

Could anyone please let me how can I achieve the same in Qlik Sense?

Thanks,

S K

[satishkurra]

See if this link helps

Customised Pop up in Sense | Qlik Community

[devarasu07]

hi,

try to use line bar combo. in qliksense there is a option called marker u can choose that option instead of bar.

(i.e: for the 3 measure set type as bar and last one measure set type as marker).

[kicchu465]

Hi Devarasu,

By Using the Combo chart the orientation is not possible.

I need the bars to be displayed horizontally.

Thanks,

S K

[OmarBenSalem]

Maybe use  a simple bar chart:

put ur 3 measures

and as ur dimension:

YourDimension&' : '& aggr(rank(YourDimension,YourMeasure),YourDimension)

per analogy, sthing like this:

=[OICA region]&': rank by car production:'& aggr(rank([OICA region],[Car production]),[OICA region])

result:

[OmarBenSalem]

and if u want to color ur measures as u want, create the measures as master item and affet colors to them:

result:

[kicchu465]

Hi Omar,

Thanks for your reply.

I am using Drill down as my Dimension. Will the above logic works drill down as well.

Thanks,

SK

[kicchu465]

Hi,

The below are the three Dimesions which I am using in Drill Down.

Dim1: =if([field1]<>'text',[field1])

Dim2: = if(field2<>'text2',field2)

Dim3 : field3

Thanks,

S K

[OmarBenSalem]

Please try to adapt this logic to ur case:

I mean if u have a drill down dimension composed of dim1 and dim2

-u are in dim1 when u do not select a value in dim1

=> if u select a value from dim1, u're in dim2

so; ur dimension would be sthing like:

dim 1 :

=dim1&

aggr(if( count(distinct dim1)<>1,

' rank is '& aggr(rank(dim1,yourMeasure),dim1),''),dim1)

dim2:

=dim2&

aggr(if( count(distinct dim1)=1,

' rank is '& aggr(rank(dim2,yourMeasure),dim2),''),dim2)

per analogy:

Please, don't forget to mark as helpful the answers that has been helpful to u, and correct the correct answer

[kicchu465]

Hi Omar,

I have tried this but the output is not as expected.

Is there any other way to do this.

Thanks

S K