Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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
Community Browser