Use Excel

[mr_ramshini]

Hi All

I have a excel file that it has a table

i want use a value of this table on gauge chart in qlik view

please help me

for example i want show a value of a sheet in a unique chart

[marjan_it]

whats your meaning exactly?! you can load your data sheet and then use of data in any object in your file.

say your data you want to show in gauge that I make It for you.

[mr_ramshini]

Hi and Thanks

In my sheets i have several data but i want use 1 value of all values in my sheet

In fact i have 12,14,10 values but i want use of 14 only

[marjan_it]

your excel file have 6 sheet with not good data. which of them is your main sheet?

for example for sheet 5 you can use it like the attached file. but if your data was good you can use many different chart and gauge.

[mr_ramshini]

Thanks

Can you send example file to me?

[marjan_it]

I attach an example file. Is not your answer?!

[mr_ramshini]

where are your example?

i wait to see your sample

thanks

[marjan_it]

I attached the file in above. excelfie.qvw

[mr_ramshini]

I can't get your sample

please send it again

[mr_ramshini]

Can I focused all my data in a sheet?

How?