topic Re: select value from listbox in QlikView

select value from listbox

Mon, 23 Jun 2014 11:22:58 GMT

suppose i have 4 values in listbox named as bucket having values as on Time,15-30,30-60,>60

i want to create a chart only for on time,what will be the expression in calculated dimension

Re: select value from listbox

Mon, 23 Jun 2014 11:24:19 GMT

i tried if(wildmatch(Bucket,'On Time')Bucket)

But it won't work,display wrong result

Re: select value from listbox

MayilVahanan — Mon, 23 Jun 2014 11:27:00 GMT

Try like this in expression

=Sum({<Bucket = {'On Time'}>}Sales)

Re: select value from listbox

Mon, 23 Jun 2014 11:31:12 GMT

You don't have to use a calculated dimension here: define the scope of the analysis in the expression like this:

=Sum({<Bucket = {'On Time'}>} Value)

Re: select value from listbox

Mon, 23 Jun 2014 11:35:24 GMT

if want to display airline?

Re: select value from listbox

Mon, 23 Jun 2014 11:43:44 GMT

Use airline as dimension and the above expression for the data values. That way only airlines that were 'On Time' wil be displayed

Re: select value from listbox

er_mohit — Mon, 23 Jun 2014 11:47:51 GMT

Try this in calculated dimension side

aggr(only({<Bucket = {'On Time'}>} airline),airline)

check on suppress null value

Re: select value from listbox

Mon, 23 Jun 2014 12:16:17 GMT

not useful for me

Re: select value from listbox

Mon, 23 Jun 2014 12:40:31 GMT

i have already created chart

dimension:

expression:

Expression

=Count( {<FlightType={'Departure'},FlightDestType={'International','Domestic'} >} IF(WildMatch(NatureCode,'*1*','*8*','*5*'), FLNO))

if i selected indigo flight it display

the new requirement is ,I have to create a new chart for only On Time

for this i used the following

Expression

=(Count( {<Bucket={'On Time'},FlightType={'Departure'},FlightDestType={'Domestic'} >} IF(WildMatch(NatureCode,'*1*','*8*','*5*'), FLNO)))

dimension

=Aggr(Only({<Bucket_new={'On Time'}>}AirlineName),AirlineName)

but selction of indigo and other flight it display wrong result as compare to other

like in indigo

it show 100% instead of 91%

Any sugg??

Re: select value from listbox

Anonymous — Mon, 23 Jun 2014 12:48:01 GMT

Use

=Count({<Bucket = {'On Time'}>} Airlines)

This will give you the count of the number times an airlines was on time.

Plot this against the Airlines name.

Re: select value from listbox

Tue, 24 Jun 2014 05:48:01 GMT

how to fetch the only one value of bucket and show in other but the value should remain same

as in previous chart with whole bucket ,on time value in 92%,then if i create one more chart which fetch only on time out of all 4 value of bucket ,value of on time should remain same as previous i.e. 92%