topic Re: How to use imported excel data in formula in Qlik Sense Advanced Authoring
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670753#M1160
<P>Hi, thanks for your reply.</P><P> </P><P>It should be correctly connected since I'm able to get the correct numbers when put it on a table and display each cost category togewhter with the product separately. It's when I try to put in the formula in a KPI figure (since I'm interested to know the total cost dispite category, and then use my filters to indentify total cost per area) it doesn't work. It only asking me to aggregate, but if I do that the uniqe category cost blends out and is no longer accurate.</P>Thu, 30 Jan 2020 07:59:32 GMTJohanSOL2020-01-30T07:59:32ZHow to use imported excel data in formula
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670516#M1154
<P>Hi,</P><P> </P><P>I have loaded excel sales cost sheet into Qlik Sense, there are x numbers of categories with diffrent prices. I then combined this with data from the sales systems database. When I look at each category the turnover looks correct (Cost Category A x 50 units = X). But when I try to summarize my total sales cost I have to use an aggrevation which is not possible in this case, how should I do to get the total sum of all categories? </P><P>"Count(distinct transactions) x Sales Cost"</P><P>Thanks in advance for your help with this!</P><P>Kindly,</P><P>Johan</P>Wed, 29 Jan 2020 14:40:48 GMThttps://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670516#M1154JohanSOL2020-01-29T14:40:48ZRe: How to use imported excel data in formula
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670526#M1156
<P>need a lot more information i am afrai.</P><P>Make sure the excel is linked correctly to your main table in the qlik app with correct column names</P>Wed, 29 Jan 2020 15:01:42 GMThttps://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670526#M1156dilipranjith2020-01-29T15:01:42ZRe: How to use imported excel data in formula
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670753#M1160
<P>Hi, thanks for your reply.</P><P> </P><P>It should be correctly connected since I'm able to get the correct numbers when put it on a table and display each cost category togewhter with the product separately. It's when I try to put in the formula in a KPI figure (since I'm interested to know the total cost dispite category, and then use my filters to indentify total cost per area) it doesn't work. It only asking me to aggregate, but if I do that the uniqe category cost blends out and is no longer accurate.</P>Thu, 30 Jan 2020 07:59:32 GMThttps://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/How-to-use-imported-excel-data-in-formula/m-p/1670753#M1160JohanSOL2020-01-30T07:59:32Z