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_NAME | NPS |
NPS | Promotor |
NPS | detractor |
TNPS | promotor |
TNPS | detractor |