topic Re: detached function in QlikView

detached function

Tue, 20 Mar 2012 18:57:54 GMT

Hi everyone,

can someone help me with a permanently detached function?

Count(DISTINCT{$<SUBSCRIPTIONS.is_subscribed = {'1'}>}SUBSCRIPTIONS.email)

i read a solution adding {1} in the expression but nothing happend

Count(DISTINCT{$1<SUBSCRIPTIONS.is_subscribed = {'1'}>}SUBSCRIPTIONS.email))

Thanks

gerardo

detached function

Wed, 21 Mar 2012 18:41:23 GMT

can you give me some advice?

Thanks

gerardo

detached function

m_woolf — Wed, 21 Mar 2012 19:05:20 GMT

Get rid of the dollar sign

Re: detached function

Wed, 21 Mar 2012 19:41:09 GMT

Hi mwoolf,

I tried to do this but when i select something the graph change….i want to detach the graph even when i re-open the application.

Other idea?

Thanks

gerardo

De: mwoolf

Enviado el: miércoles, 21 de marzo de 2012 04:06 p.m.

Para: Pauza, Gerardo

Asunto: - Re: detached function

QlikCommunity <http://community.qlik.com/index.jspa>

Re: detached function

created by mwoolf <http://community.qlik.com/people/mwoolf> in New to QlikView - View the full discussion <http://community.qlik.com/message/203089#203089

detached function

m_woolf — Wed, 21 Mar 2012 19:44:16 GMT

You might try attaching your qvw. The chart should not change with the $ removed.

detached function

Wed, 21 Mar 2012 20:04:17 GMT

Count({1<SUBSCRIPTIONS.is_subscribed = {'1'}>} DISTINCT SUBSCRIPTIONS.email))

Distinct should be after the set expression

Re: detached function

Wed, 21 Mar 2012 20:22:36 GMT

Thanks marcsliving,

And if i have an expression like this:

=if(match(DEALS.city_id,42556), CALENDARIO_DEAL_EXTERNALS.AñoMes)

When i do clik in any AñoMes the graph change too.

Can i detach permanently that expression?

Thanks

gerardo

De: marcsliving

Enviado el: miércoles, 21 de marzo de 2012 05:05 p.m.

Para: Pauza, Gerardo

Asunto: - Re: detached function

QlikCommunity <http://community.qlik.com/index.jspa>

Re: detached function

created by marcsliving <http://community.qlik.com/people/marcsliving> in New to QlikView - View the full discussion <http://community.qlik.com/message/203113#203113

detached function

Wed, 21 Mar 2012 20:27:13 GMT

Set is for chart aggregation so if you are doing a sum,avg, or count then yes.

sum(1{<DEALS.city_id={'42556'}>}CALENDARIO_DEAL_EXTERNALS.AñoMes)

Re: detached function

Wed, 21 Mar 2012 20:57:27 GMT

Thanks marcsliving.

De: marcsliving

Enviado el: miércoles, 21 de marzo de 2012 05:27 p.m.

Para: Pauza, Gerardo

Asunto: - Re: detached function

QlikCommunity <http://community.qlik.com/index.jspa>

Re: detached function

created by marcsliving <http://community.qlik.com/people/marcsliving> in New to QlikView - View the full discussion <http://community.qlik.com/message/203121#203121