Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-12-04 12:43 AM

How To convert calculation from qlik sense to tableau

Hi All,


I want to know, how the following conditions from Qlik sense to be converted into Tableau readable conditions.

sum(IF(YYYYMM=$(vCM),[QU_ITM_LM_RTN_SLS],0))/Count ( distinct IF(YYYYMM=$(vCM),ID_TRN,0))-

sum(IF(YYYYMM=$(vCM)-1,[QU_ITM_LM_RTN_SLS],0))/Count ( distinct IF(YYYYMM=$(vCM)-1,ID_TRN,0))

Thanks In Advance,

Natasha

891 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2017-12-21 03:43 AM

You should post into Tableau forum not Qlik.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
806 Views