Custom dimensions on chart lines

[qlikviewwizard]

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:

Please advise.

Thanks in advance.

[NareshGuntur]

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]

Hi ,

Can you share that Sales Excel file.

Regards

Dhasharadh

[qlikviewwizard]

No,

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

[Kushal_Chawda · Accepted solution]

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]

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

Cheers,

Naresh

[HirisH_V7]

Hi ,

I hope you require like this,

Regards,

Hirish

[MayilVahanan]

HI

Try like this

In Conditional Expression

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