topic Re: Custom dimensions on chart lines in QlikView

Custom dimensions on chart lines

qlikviewwizard — Sat, 28 Nov 2015 03:29:41 GMT

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.

Re: Custom dimensions on chart lines

NareshGuntur — Sat, 28 Nov 2015 06:18:15 GMT

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?

Re: Custom dimensions on chart lines

dhasharadh — Sat, 28 Nov 2015 06:27:17 GMT

Hi ,

Can you share that Sales Excel file.

Regards

Dhasharadh

Re: Custom dimensions on chart lines

qlikviewwizard — Sat, 28 Nov 2015 06:46:15 GMT

No,

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

Re: Custom dimensions on chart lines

Kushal_Chawda — Sat, 28 Nov 2015 07:01:07 GMT

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

Re: Custom dimensions on chart lines

NareshGuntur — Sat, 28 Nov 2015 07:04:30 GMT

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

Cheers,

Naresh

Re: Custom dimensions on chart lines

HirisH_V7 — Sat, 28 Nov 2015 07:08:28 GMT

Hi ,

I hope you require like this,

Regards,

Hirish

Re: Custom dimensions on chart lines

MayilVahanan — Sat, 28 Nov 2015 07:20:38 GMT

Try like this

In Conditional Expression

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