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
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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: 
Not applicable
‎2015-02-18 04:57 AM

If condition with two columns joining together

Good day experts,

I have a very simple question but with Qlikview it seems not that simple. I have two columns the NPS column is aggregated and I have to calculate that on the montly basis. The problem I am facing in joining the data from two different tables. I have to make the line graph to show the development of both the question _name. for example I want to have

" if(question_name='nps' and ROUND(sum(if(NPS='Promotor',1)) / count(TOUCHPOINT)*100

- (sum(if(NPS='Detractor',1)) / count(TOUCHPOINT)*100))

The statement which starts from round gives me aggregated value which I have to use.

Similarly I want the same from other question name as well

QUESTION_NAMENPS
NPSPromotor
NPSdetractor
TNPSpromotor
TNPSdetractor
339 Views
0 Likes
0 Replies