Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

select value from listbox

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

10 Replies
Not applicable
Author

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

But it won't work,display wrong result

MayilVahanan

Hi

Try like this in expression

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

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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)
Not applicable
Author

if want to display airline?

Not applicable
Author

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

er_mohit
Master II
Master II

Try this in calculated dimension side

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

check on suppress null value


Not applicable
Author

not useful for me

Not applicable
Author

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??

shekharnil
Contributor III
Contributor III

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.