Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
kicchu465
Contributor

Migrating Bar Chart from Qv to Qs

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

10 Replies
satishkurra
Valued Contributor II

Re: Migrating Bar Chart from Qv to Qs

devarasu07
Honored Contributor II

Re: Migrating Bar Chart from Qv to Qs

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).

Capture.JPG

kicchu465
Contributor

Re: Migrating Bar Chart from Qv to Qs

Hi Devarasu,

By Using the Combo chart the orientation is not possible.

I need the bars to be displayed horizontally.

Thanks,

S K

Partner
Partner

Re: Migrating Bar Chart from Qv to Qs

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:

Capture.PNG

Partner
Partner

Re: Migrating Bar Chart from Qv to Qs

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

Capture.PNG

result:

Capture.PNG

kicchu465
Contributor

Re: Migrating Bar Chart from Qv to Qs

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
Contributor

Re: Migrating Bar Chart from Qv to Qs

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

Partner
Partner

Re: Migrating Bar Chart from Qv to Qs

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:

Capture.PNG


Capture.PNG

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

kicchu465
Contributor

Re: Migrating Bar Chart from Qv to Qs

Hi Omar,

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

Is there any other way to do this.

Thanks

S K