Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have created a dashboard in QlikView and exporting it to Excel Sheet.Later if I try to do Sum in Excel by applying some condition,it is returning 0.But for some other sheets, it is returning values correctly.Can anyone please help?
Hi Vani,
Check that that the uploaded data in Excel have a number format.
Regards,
Andrey
Hi Andrey
I am getting values correctly, but the problem is that Excel is displaying like some condition has been applied to that cell
Hi,
Can you share your sample app. Tks
Hi Deavarasu
Attached exported file,problem is in Excel only as all values are coming correctly from QlikView
Hi,
Look at the attahced file
Here one yellow colour button is there. There click on convert to number.
After that try to sum.
Regards
Hi Tripati
I am not getting values when I have currency symbol infront of number,if I remove it and apply the thing you have said values are coming perfectly
Hi Vani,
The sum is showing.
Please check.
Hi
I haven't understood how you are doing it.Can you explain?As I am not getting yellow color box for whole column as you.
Please see the attached where I have added two different options and explained my workings so you can see how it is done