List Box Problem

[Anil_Babu_Samineni]

Hello Community,

In my excel, i have like

Ename, Sal

A, 10

B, 20

C, 30

While i ma fetching this data to list box in Qlikview. I got three names but, I am getting 1 more space space also will come. Can you assist me please

[Anil_Babu_Samineni]

This is Live, Check this and Let me know. For Main sheet i have Furnace - Check why this Space came?

Second Issue

Shee2 -- I have Drill down. If we select then should show associative only. Please choose Plant and see. Why This Others will showing here?

[avinashelite]

use this condition in the list box

if(len(trim(Furnace))>0,Furnace)

if you want to eliminate the data the script level then use the condition in the script level

Issue2 : The problem is with the Expression what you have written , its not finding any count for the set analysis what you have written hence its not showing the result , to check this just disable the current condition and add a simple expression like 1 then try the drill down

Hope this helps you

[beck_bakytbek]

Hi Anil,

You can use whithin your ListBox: check in General: Field: Expression:

and enter this Expression: if(Ename= '-',Null(),Ename)

i hope that helps

beck

[Anil_Babu_Samineni]

First one is Resolved and how about Second one?

PFA. Here, Why - Values showing.

[avinashelite]

Go to chart Properties > Dimensions > check  the suppress null values .

This is resolve the second issue

[Anil_Babu_Samineni]

Yes, But That is the Second Dimension in Drill Down

[avinashelite]

It will apply for the all the dimensions rite ?? please check

[Chanty4u]

try this

Alt(Ename,' ') as Ename,

or

If(Len(Trim(Ename))=0,' ',Ename) As Ename