Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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 - Specialist
Partner - Specialist


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

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
Please close the thread by marking correct answer & give likes if you like the post.