topic Re: Set analysis filter in QlikView

Set analysis filter

marco_puccetti — Fri, 29 May 2015 08:42:48 GMT

Hello, i need to get in a pivot table a list of video of a specific channel, this statement is not ok:

{< VideoSearch_channelTitle = {"keyword"}>}VideoSearch_channelTitle

I need only the VideoSearch_channelTitle related to the keyword.

Thanks

Marco

Re: Set analysis filter

anbu1984 — Fri, 29 May 2015 08:45:54 GMT

Can you post the complete expr? Is this calculated dimension or expr?

Re: Set analysis filter

marco_puccetti — Fri, 29 May 2015 08:55:18 GMT

The field is the first dimension of a table, and now is set to VideoSearch_channelTitle, but i need all the VideoSearch_channelTitle having the value of a specific keyword i.e. Marco.

Is it possible?

Marco

Re: Set analysis filter

anbu1984 — Fri, 29 May 2015 09:02:42 GMT

Yes. Try like this

=Aggr(Only({<VideoSearch_channelTitle={'Marco'}>} VideoSearch_channelTitle),VideoSearch_channelTitle)

EDIT: Also check "Suppress when value is null" for this dimension

Re: Set analysis filter

marco_puccetti — Fri, 29 May 2015 09:10:36 GMT

In alternative i could act at the origin of the datas in the script editor and force to load only a subset of datas.

This expression doesn't work:

let site ='pippo';

TAB:

LOAD

kind as VideoSearch_kind,

videoId as Video_id,

videoLink as VideoSearch_videoLink,

publishedAt as VideoSearch_publishedAt,

timestamp#(left(publishedAt, 10) & ' ' & mid(publishedAt, 12, 8), 'YYYY-MM-DD hh:mm:ss') as VideoSearch_publishedAt_qlik_timestamp,

Date(date#(left(publishedAt, 10), 'YYYY-MM-DD'),'DD-MM-YYYY') as VideoSearch_publishedAt_qlik_date,

channelId as VideoSearch_channelId,

channelLink as VideoSearch_channelLink,

channelTitle as VideoSearch_channelTitle,

title as VideoSearch_title,

description as VideoSearch_description,

thumbnailDefaultUrl as VideoSearch_thumbnailDefaultUrl,

liveBroadcastContent as VideoSearch_liveBroadcastContent

FROM

[$(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$(site)](qvx)

where VideoSearch_channelTitle=$(site);

Is there anything wrong?

Marco

Re: Set analysis filter

anbu1984 — Fri, 29 May 2015 09:15:59 GMT

Add quotes around $(site)

where VideoSearch_channelTitle='$(site)';

Re: Set analysis filter

marco_puccetti — Fri, 29 May 2015 09:40:44 GMT

Thanks not it works.

Marco