Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all.
I'm a newbie on the Qlikview World, so I really need your help
I've been looking on the forums and I can't found an exact answer to my problem.
I have a bar chart and a dimension called "Values". When I selected items from "Values", they appears on the chart. My problem is that besides the selected data I need to add a new one called 'Others', that contains the summatory of the non selected data.
I found that expression
if(dimensionality(),sum({<product =e(product)>}sale),sum(sale))
With this, the selected values are not shown on the chart, only the non selected (great, I need this), but I don't know how to combine to obtain the selected data and the 'Others' in the same chart
Thanks a lot
Thanks Jason, on the chart the values of the category are shown separately. But trying to create the chart, all those categories that were selected (distinct to 'Others'), the expression calculate the total value of the selection for each bar, instead de individual quantities.
Ah. Oops. Will take a look later.
Hi,
Your expression shoule be as shownbelow.
Dimension Expression:
=if(WildMatch(TEST,$(=Chr(39)&Concat({<TEST= e(TEST)>} TEST,chr(39)&','&chr(39))&Chr(39))),'Others',TEST)
Value Expression:
=Sum (Value)+SUM({<TEST =e(TEST)>} Value)
Have a look at the attached application.
Hope this may help you.
-Sridhar
Thanks for your answer
I tried the last approach, that means, I only replaced the dimension and the expression with your suggestion, but it didn't work.
I realised that the 'characteristic_value' variable don't appear on your expressions. Should it be specified elsewhere in the apllication?
I have the personal edition of qlikview, so I can't open your file
Bye
Sorry for the delayed answer mate - I had my expression slightly wrong. Instead of:
if($(vValueList) = 'Others',
sum({<characteristic_value=E()>} fact_sold_units),
sum(fact_sold_units)
)
you need:
if($(vValueList) = 'Others',
sum({<characteristic_value=E()>} fact_sold_units),
sum(IF(characteristic_value=$(vValueList),fact_sold_units))
)
See attached,hope it helps,
Jason
Great, The last answer works perfectly
Thanks a lot for all your support !!!