Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Arjunarao
Honored Contributor II

Custom dimensions on chart lines

Hi All,

I am analysing data on 3 dimension objects and 4 pick metrics in the graph.

I don't want to show the lines for ENAME dimension in cyclic selection.But want to show the lines for Item and Country dimensions.

expected results for ENAME dimension selection:

Capture1.PNG

Please advise.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted

Re: Custom dimensions on chart lines

You can do this like below

Put below expression in Conditional of all line expressions

=if(GetCurrentField(DIMENSIONS)='ENAME',0,if(GetSelectedCount(_metrics) > 0 and SubStringCount(Concat(_metricsNo, '|'), 1),1))

like for others

See the attached

View solution in original post

7 Replies
Partner
Partner

Re: Custom dimensions on chart lines


In your attached qvw, you mean you don't want to show the values GERMANY, INDIA, JAPAN etc but when drilled down to next level, it should show the value?

dhasharadh
Contributor II

Re: Custom dimensions on chart lines

Hi ,

Can you share that Sales Excel file.

Regards

Dhasharadh

Arjunarao
Honored Contributor II

Re: Custom dimensions on chart lines

No,

When I select pick metrics (1) and ENAME(2) of Cyclic Dimension lines (3) should be disappear.

Capture.PNG

Highlighted

Re: Custom dimensions on chart lines

You can do this like below

Put below expression in Conditional of all line expressions

=if(GetCurrentField(DIMENSIONS)='ENAME',0,if(GetSelectedCount(_metrics) > 0 and SubStringCount(Concat(_metricsNo, '|'), 1),1))

like for others

See the attached

View solution in original post

Partner
Partner

Re: Custom dimensions on chart lines

Please check the attached qvw and let me know if this is what you want.

Cheers,

Naresh

HirisH_V7
Honored Contributor

Re: Custom dimensions on chart lines

Hi ,

I hope you require like this,

Cyclic Drill.PNG

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”

Re: Custom dimensions on chart lines

HI

Try like this

In Conditional Expression

=GetSelectedCount(_metrics) > 0 and SubStringCount(Concat(_metricsNo, '|'), 1) and GetCurrentField(DIMENSIONS) <> 'ENAME'