This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
Thanks in advance.
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
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?
Can you share that Sales Excel file.
When I select pick metrics (1) and ENAME(2) of Cyclic Dimension lines (3) should be disappear.
Please check the attached qvw and let me know if this is what you want.
I hope you require like this,
Try like this
In Conditional Expression
=GetSelectedCount(_metrics) > 0 and SubStringCount(Concat(_metricsNo, '|'), 1) and GetCurrentField(DIMENSIONS) <> 'ENAME'