topic Re: importing just one item from exist table in QlikView

importing just one item from exist table

nazaninslp — Sat, 30 Jun 2018 07:22:19 GMT

Dears

I have one chart that shows all of my offers and the usage and count of qualified subscribers that is connected to one table,

now I want just show one of them(from connected table) in other chart separately, would you please help me how can I seperate it in one chart that show just one item that I want.

for exampale:

I have below table

I want to import just first item in my dashboard not whole of them.

Thank you

Re: importing just one item from exist table

felipedl — Mon, 02 Jul 2018 10:46:12 GMT

Hi Nazanin,

you can use set analysis for it, like so:

let's say you want average daily data usage

avg({<[CAMPAIGN_NAME]={"1 GB Churn Same day"}>}Data)

Bolded part is the set analysis, which lets you filter on a graph a specific dimension value.

Felipe.

Re: importing just one item from exist table

nazaninslp — Tue, 03 Jul 2018 05:25:34 GMT

Hi Felip

it is not matter AVG,SUM or ..., I just want to show and inport just one campaign name and its value like a piture that I have shared before.

but when i want import the campaign name , all of campaigns name imported in table, I just want to one of them not whole.

would you please help.

Re: importing just one item from exist table

felipedl — Tue, 03 Jul 2018 12:16:22 GMT

When loading your campaign table, use the [CAMPAIGN_NAME] as a where clause

Campaign:

Load

From [Whatever]

Where [CAMPAIGN_NAME]="1 GB Churn Same day"

That will only load one campaign.

Re: importing just one item from exist table

nazaninslp — Wed, 04 Jul 2018 11:29:42 GMT

Dear Felip

in other sheet I need my all campiagns list and their usage, so if i limited the campiagn_name just for mentioned item, the others will not load.

is there any way to do it in expression part.

Thank you for your big cooperation.

Re: importing just one item from exist table

felipedl — Wed, 04 Jul 2018 15:56:59 GMT

It's exactly what I pointed out before, use set analysis in expression, like:

avg({<[CAMPAIGN_NAME]={"1 GB Churn Same day"}>}Data)

Or whatever other campaign name you want.

This will only get one campaign in the expression, even though you loaded all of them.