detached function

[#1]

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

[#2]

can you give me some advice?

Thanks

gerardo

[m_woolf]

Get rid of the dollar sign

[#4]

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

[m_woolf]

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

[#6 · Accepted solution]

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

Distinct should be after the set expression

[#7]

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

[#8]

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)

[#9]

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