New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Creator

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
Specialist II
Master II

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

Creator
Author

Hi Devarasu,

By Using the Combo chart the orientation is not possible.

I need the bars to be displayed horizontally.

Thanks,

S K

MVP

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:

MVP

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

result:

Creator
Author

Hi Omar,

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

Thanks,

SK

Creator
Author

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

MVP

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:

Creator
Author

Hi Omar,

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

Is there any other way to do this.

Thanks

S K

Tags
Community Browser