Discussion board where members can get started with QlikView.
Can someone please suggest what can be done to achieve this?I have a table that returns following.
Users wants to see this on the chart.
Sandiago and LA belongs to California,so the values of individaul cities should be added to the State value.And in the chart only State name would be visible (no city name).
i tried but not getting proper answer.if u get correct answerplease let me know.
plz find the attachement .
may it helps you
Hi, try with this
MAPPING LOAD * INLINE [
LOAD applymap('Map', Name) as Name2, * INLINE [
Load Name2 as Name,
sum(Value) as Value
group by Name2;
drop table Data1;
you should first insure that how they should beelong to perticular state
if city's are link to state then it will easy to calculate.
on the basis of this table we can not achieve like that
I created a calculated dimension and it worked fine.Plz find attached.
Sorry to response you late you have to maintain a second table which contains details of the State and cities see the script
load * inline
This will give you a correct result as you want just add details in second table and reload it.
See the attached sample also
Let me know about this if not works.