Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count({1<SUBSCRIPTIONS.is_subscribed = {'1'}>} DISTINCT SUBSCRIPTIONS.email))
Distinct should be after the set expression
can you give me some advice?
Thanks
gerardo
Get rid of the dollar sign
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
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
You might try attaching your qvw. The chart should not change with the $ removed.
Count({1<SUBSCRIPTIONS.is_subscribed = {'1'}>} DISTINCT SUBSCRIPTIONS.email))
Distinct should be after the set expression
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
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
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)
Thanks 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