bar graph

[#1]

hallo Everybody,

I have attached the file for reference. Blue part of the file shw the actual data while the green part show the drived data.

Question

Is it possible to make an automatic dimension like <=3 <=6 <=11 <=21 and <=41 based upon 20% cluster which i have already made in the graph.

I am very new to Qlikview please guide me how can I make the calcuation.

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Hello Wassenaar,

I am very thankful to you for the great help. I will try myself as well. Thanks again for the support. If I have a problem in future, Can I send you a private message or should always post here.

[Gysbert_Wassenaar]

Always post here so more people can try to help you.

[#5]

Hallo Wassenaar,

just a small question in the excel file which I have attached earlier as well. The blue column is the only column I have, the rest of the columns were self calculated. my question is, Is it possible to calculate them via script in Qlikview rather calculating it in Excel and then upload it.

[Gysbert_Wassenaar]

No, it's impossible to calculate the second column from the first.