Duplicate values in bar Chart

[#1]

Dear experts,

I am trying to create a bar chart with 2 dimensions, however I am ending up with duplicate values,

the expressions are as follows:

Bar chart .. Sum(cash)

line graph .. Sum({$<BDF_Type={"*profit*"}, YEAR = {'2015'} >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR = {'2015'} >} cash)

I have attached screen shot for your reference.

Kind regards,

Royce

[sdmech81]

Hi,

Restrict ur dimension in Calculated dimension tab.

Sachin

[#3]

What if I want only the total fiscal years such as 2015/2016/2017 to be in the selection and not other date values ? I think I tried that option out and it gave me back values for every month as well

[sdmech81]

For Year u just say:

=Only({<Year={'2015'}>}Year)

Sachin

[sasikanth]

Please share a sample data set along with the requirement ,it would be easy to resolve .

[sdmech81]

Duplicates u r seeing bcs ur dimensions conatin that data and Qlikview is interpreting it correctly only.

Which all u don't want to see restrict in Calculated dimension bcs u gt 2 dimnesons, like as said above n try:)

sachin

[#7]

Sum({$<BDF_Type={"*profit*"}, Only({<Year={'2015'}>}Year) >} cash) / Sum({$<BDF_Type={"*revenue*"}, Only({<Year={'2015'}>}Year) >} cash)

is this what you mean ?

[#8]

or is the expression

Sum({$<BDF_Type={"*profit*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash)

[#9]

heya Chanty do you know where to apply the only() function ? I have tried it inthe syntax and all, it does not work

[Chanty4u]

Try this

=Sum({$<BDF_Type={"*profit*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash) / Sum({$<BDF_Type={"*revenue*"}, Only({$<Year={'2015'}>}Year) >} cash)

[#11]

thanks for helping out again buddy ! however I am getting an error in set modifier expression showing up