Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Currency converssions

hi all please give me a solution for below query

In Qlik sense,

i have a pivot table with geographical wise Monthly Target sales and actual saleS,

Question: I want to create YTD to display all months target sales sum and all months actual sales sum and I want to find what is the percentage of total actual sales sum in target sales sum.PLEASE GO THROUGH THE BELOW TABLE

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10
GeographyAPRL-2016APRL-2016MAY-2016MAY-2016JUN-2016JUN-2016YTDYTDPER(%)
TAR_SALEAC_SALETAR_SALEAC_SALETAR_SALEAC_SALETAR_SALEAC_SALE
US100080012001400160014003800360094.73

MY DIMENSSION IS :GEOGRAPHY

MEASURE Smiley FrustratedUM(AMOUNT_INR.)

COLUMN S ARE :MONTH_NAME  AND SALES_TYPE(TAR_SALES, AC_SALES)