Set analysis filter

[marco_puccetti]

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

[anbu1984]

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

[marco_puccetti]

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

[anbu1984]

Yes. Try like this

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

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

[marco_puccetti]

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

[anbu1984 · Accepted solution]

Add quotes around $(site)

where VideoSearch_channelTitle='$(site)';

[marco_puccetti]

Thanks not it works.

Marco