topic Re: Combo Chart(Trend line for selected Brands) in QlikView

Combo Chart(Trend line for selected Brands)

israrkhan — Sun, 31 May 2015 10:15:01 GMT

Hi Guys...

I have a combo chart.where i have one dimension which is Week, and one expression which is sum({1}Sale), display option is Bar.

now i have to show trend line for brands, i have around 50 brands..i want to give option to user to select up to 6 brands and see the trend line for selected brands, out of total sale...

the solution comes in mind is to add conditional expressions for each Brand...but in this case i have to add around 50 conditional expressions in the chart...

is there any way to do this with minimum expressions...

Many Thanks,,,,

Re: Combo Chart(Trend line for selected Brands)

antoniotiman — Sun, 31 May 2015 11:09:42 GMT

Hi,

I think this is what You want.

Regards,

Antonio

Re: Combo Chart(Trend line for selected Brands)

Anonymous — Sun, 31 May 2015 11:11:17 GMT

Could you use something like this in 6 expressions for Set Analysis selection ?

subfield(GetFieldSelections(Brand),',',1)

Where the 1 will return the first Brand selected and then do the same to 2, 3, 4, 5 & 6.

Re: Combo Chart(Trend line for selected Brands)

israrkhan — Sun, 31 May 2015 11:17:38 GMT

Thanks for the reply...

but i want to see separate trend line for each selected brand...

if i select 3 brands, then i want to see 3 lines for each selected brands....

Re: Combo Chart(Trend line for selected Brands)

israrkhan — Sun, 31 May 2015 11:47:43 GMT

Hi Bill,

this expression gives me Brands name in text boxes correctly...

=SUM({<Brand.COMM_NM = {'$(=subfield(GetFieldSelections(Brand.COMM_NM),',',1))'}>} SellOut.QTY)

but when i use this in chart, it does not show line for all selected brands, it show only for last selected brand...

any idea...

Many Thanks

Re: Combo Chart(Trend line for selected Brands)

Anonymous — Sun, 31 May 2015 14:24:51 GMT

Just noticed there is a leading space that needs trimming away :

=SUM({<Brand.COMM_NM = {'$(=trim(subfield(GetFieldSelections(Brand.COMM_NM),',',1)))'}>} SellOut.QTY)

Re: Combo Chart(Trend line for selected Brands)

MK_QSL — Sun, 31 May 2015 15:30:05 GMT

You need to use many expressions in your application...

something like below.. May be wait for someone with better solution.

For 1st Expression

Conditional

$(=GetSelectedCount(Brand))>=1

Label

='Sales for Brand : '& SubField(GetFieldSelections(Brand,':'),':',1)

Definition

=SUM(TOTAL <YearWeek> {<Brand = {"$(=SubField(GetFieldSelections(Brand,':'),':',1))"}>}Sales)

For 2nd Expression

Conditional

$(=GetSelectedCount(Brand))>=2

Label

='Sales for Brand : '& SubField(GetFieldSelections(Brand,':'),':',2)

Definition

=SUM(TOTAL <YearWeek> {<Brand = {"$(=SubField(GetFieldSelections(Brand,':'),':',2))"}>}Sales)

and so on...