Discussion board where members can get started with QlikView.
Hi all i want to calucalte the % for the 3 measures based on dimension and i have type service and hadrware
05-negative....... like that
service% = sum(01+02)/All_salestge = where type is service
hardware% = sum(01+02)/All_salestge = where type is hardware
total% = sum(01+02)/All_salestge
instead of hard coding is there any other way to get dynamic?
and i want two seperate tables in attached image the same way they wanted to see
top table should have the totals
below it with percentages.