8 Replies Latest reply: Mar 21, 2012 4:57 PM by gerardo.pauza

detached function

gerardo.pauza Mar 20, 2012 2:57 PM

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

gerardo.pauza Mar 21, 2012 2:41 PM (in response to gerardo.pauza)

can you give me some advice?

Thanks
gerardo
Like Show 0 Likes (0)

Actions
detached function

m w Mar 21, 2012 3:05 PM (in response to gerardo.pauza)

Get rid of the dollar sign
Like Show 0 Likes (0)

Actions
- Re: detached function
  
  gerardo.pauza Mar 21, 2012 3:41 PM (in response to m w)
  
  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 qliktech@sgaur.hosted.jivesoftware.com
  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
  
  Like Show 0 Likes (0)
  
  Actions
  - detached function
    
    m w Mar 21, 2012 3:44 PM (in response to gerardo.pauza)
    
    You might try attaching your qvw. The chart should not change with the $ removed.
    
    Like Show 0 Likes (0)
    
    Actions
detached function

Marc Livingston Mar 21, 2012 4:04 PM (in response to gerardo.pauza)

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

Distinct should be after the set expression
Like Show 0 Likes (0)

Actions
- Re: detached function
  
  gerardo.pauza Mar 21, 2012 4:22 PM (in response to Marc Livingston)
  
  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 qliktech@sgaur.hosted.jivesoftware.com
  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
  
  Like Show 0 Likes (0)
  
  Actions
  - detached function
    
    Marc Livingston Mar 21, 2012 4:27 PM (in response to gerardo.pauza)
    
    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)
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: detached function
      
      gerardo.pauza Mar 21, 2012 4:57 PM (in response to Marc Livingston)
      
      Thanks marcsliving.
      
      De: marcsliving qliktech@sgaur.hosted.jivesoftware.com
      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
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post