Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master 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
Kushal_Chawda

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
NareshGuntur
Partner
Partner


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
Creator III
Creator III

Hi ,

Can you share that Sales Excel file.

Regards

Dhasharadh

qlikviewwizard
Master II
Master II
Author

No,

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

Capture.PNG

Kushal_Chawda

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

NareshGuntur
Partner
Partner

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

Cheers,

Naresh

HirisH_V7
Master
Master

Hi ,

I hope you require like this,

Cyclic Drill.PNG

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
MayilVahanan

HI

Try like this

In Conditional Expression

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

Thanks & Regards,
Mayil Vahanan R