topic Re: total of three charts on the top in text box in QlikView

total of three charts on the top in text box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want total of distribution channel + gender + category in a text box ie total of (total growth)12+ 14 + 24( as seen in image)

and also total of individual expression ie 2016 and 2017

Re: total of three charts on the top in text box

avinashelite — Fri, 27 Oct 2017 10:36:17 GMT

Simply rite

count(channel )+count( gender )+ count(category ) //change according to your field names

//year 2016

count({<Year={2016}>}channel )+count( {<Year={2016}>}gender )+ count({<Year={2016}>}category )

Re: total of three charts on the top in text box

Anil_Babu_Samineni — Fri, 27 Oct 2017 10:37:45 GMT

Perhaps these?

1) Sum(TOTAL <FieldName> [GROWTH Expression])

2) Sum({<Year = {'$(=AddYears(Max(Year),-1))'}>} TOTAL <FieldName> Measure)

3) Sum({<Year = {'$(=Max(Year))'}>} TOTAL <FieldName> Measure)

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 10:51:46 GMT

=num(

if(vSelectTab2 = 'Sales View',

sum(if(Sold_Date <= MakeDate(2014,month(To),day(To)) and Sold_Date >= MakeDate(2014,month(From),day(From)), [inv value]))/Sales_INR_Unit

sum(if(Sold_Date <= MakeDate(2014,month(To),day(To)) and Sold_Date >= MakeDate(2014,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value]))/Sales_INR_Unit)

'#,##0.0')

you mean this?

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 11:01:29 GMT

This expression is giving an erro

Re: total of three charts on the top in text box

Anil_Babu_Samineni — Fri, 27 Oct 2017 11:04:13 GMT

Will you able to provide application?

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 11:15:35 GMT

What is your TOTAL GROWTH expression in the charts?

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 11:22:18 GMT

=num(

if(vSelectTab2 = 'Sales View',

sum(if(Sold_Date <= MakeDate(2015,month(To),day(To)) and Sold_Date >= MakeDate(2015,month(From),day(From)), [inv value]))/10000000

sum(if(Sold_Date <= MakeDate(2015,month(To),day(To)) and Sold_Date >= MakeDate(2015,month(From),day(From)) and [Season Code] = $(vSales_Summary_Current_Season), [inv value]))/10000000)

if(vSelectTab2 = 'Sales View',

sum(if(Sold_Date <= MakeDate(2014,month(To),day(To)) and Sold_Date >= MakeDate(2014,month(From),day(From)), [inv value]))/10000000

sum(if(Sold_Date <= MakeDate(2014,month(To),day(To)) and Sold_Date >= MakeDate(2014,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value]))/10000000)

-1

,'#,##0%')

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 11:26:11 GMT

Do you have the same expression in the three chart with different dimensions? Can you share the dimension from the charts also

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 11:34:05 GMT

for distribution channel for sales view

=num(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

'#,##0%')

for distribution channel for season view

=num(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Current_Season), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])),

'#,##0%')

for gender for sales view

=num(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

'#,##0%')

and same for other charts too

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 11:41:43 GMT

Something like this

RangeSum(

Sum(Aggr(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

[Distribution Channel])),

Sum(Aggr(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Current_Season), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])),

Season)),

Sum(Aggr(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

Gender)))

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 11:44:30 GMT

My bad, try this

RangeSum(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Current_Season), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])),

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 11:55:21 GMT

Please confirm that i have to write this in chart or text box?

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 11:56:40 GMT

I believe in a text box

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 12:04:31 GMT

well its giving an error

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 12:05:33 GMT

What is the error message?

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 12:15:15 GMT

i was able to find the error but i need data to be presented in percentage.

Re: total of three charts on the top in text box

Anonymous — Fri, 27 Oct 2017 12:18:49 GMT

like in in this image under total growth i want total of 24%,12% and 14%

Re: total of three charts on the top in text box

sunny_talwar — Fri, 27 Oct 2017 12:21:14 GMT

Add Num function around the expression

Num(Expression, '#,##0.%')

Re: total of three charts on the top in text box

Anonymous — Mon, 30 Oct 2017 03:22:23 GMT

sir

i want total for year 2016 for eg distribution channel total + gender total +category total should be seen under 2016 as in text box