topic Re: If wildmatch to return data for selected values in QlikView

If wildmatch to return data for selected values

Tue, 03 Feb 2015 13:18:04 GMT

Hi sorry guys I know this is a basic question but how do I return the names and associated data for say a list of people :

So say I've a list of names

PERSON, TRAVEL

tom, economy

bob, economy

jerry, business

mark, economy

adam, business

smith, business

So I want to show the names and the class of travel for all those who travelled 'business' ie jerry, adam and smith. I know this is a basic example but it will set me up going forward ... thanks

Re: If wildmatch to return data for selected values

Gysbert_Wassenaar — Tue, 03 Feb 2015 13:25:19 GMT

Add a table box with both fields. Then click on the value 'business' to select it. The table box will show the persons who traveled business class.

Re: If wildmatch to return data for selected values

Tue, 03 Feb 2015 14:31:56 GMT

Sorry just to be clear I meant either as a calculated dimension or in script

Re: If wildmatch to return data for selected values

Gysbert_Wassenaar — Wed, 04 Feb 2015 09:57:53 GMT

If you want to load only those records where the value of TRAVEL is 'business' you can use something like this as script:

MyTable:

LOAD PERSON, TRAVEL

FROM ...mysource...

WHERE TRAVEL = 'Business';

Re: If wildmatch to return data for selected values

mohammadkhatimi — Wed, 04 Feb 2015 10:05:07 GMT

Hi,

Try this in Calculated Dimension:

if(TRAVEL='business',PERSON)

Regards,

Er.Mohammad