topic Re: Use Excel in QlikView

Use Excel

mr_ramshini — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Use Excel

marjan_it — Sat, 20 Aug 2016 05:10:24 GMT

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.

Re: Use Excel

mr_ramshini — Sat, 20 Aug 2016 05:44:55 GMT

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

Re: Use Excel

marjan_it — Sat, 20 Aug 2016 06:13:55 GMT

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.

Re: Use Excel

mr_ramshini — Sat, 20 Aug 2016 06:15:02 GMT

Thanks

Can you send example file to me?

Re: Use Excel

marjan_it — Sat, 20 Aug 2016 07:38:26 GMT

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

Re: Use Excel

mr_ramshini — Sat, 20 Aug 2016 07:42:23 GMT

where are your example?

i wait to see your sample

thanks

Re: Use Excel

marjan_it — Sat, 20 Aug 2016 07:46:19 GMT

I attached the file in above. excelfie.qvw

Re: Use Excel

mr_ramshini — Sat, 20 Aug 2016 09:42:29 GMT

I can't get your sample

please send it again

Re: Use Excel

mr_ramshini — Sat, 20 Aug 2016 10:03:46 GMT

Can I focused all my data in a sheet?

How?

Re: Use Excel

Anil_Babu_Samineni — Sat, 20 Aug 2016 11:01:34 GMT

Hey Man, Can i know what do you want to achieve using Gauge?

Re: Use Excel

mr_ramshini — Sun, 21 Aug 2016 04:30:38 GMT

Thanks

but how i can use more one data on sheets?

you say i can use one data on my sheet