Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have attached the sample QVW file
In the Data details tab,
Using table box i am populating the data.i am hiding the column DD_ID and sorting based on it in Sort Tab{Properties}.Screenhot 1:
I have used Dual function for it in the script to hide the column in the table box and sort table rows based on it.
But when i tried to import it to excel i am getting the row number in the excel as shown in screenshot below:{Rowid 8}
The same function used for Dashboard is working fine.When you try to import it its working fine without displaying any numbers
Hi the problem is using text function i am not getting the order in which i want to display the data in excel.
its all messed up
Hi
Use straight table to solve your problem. PFA, refer sheet2
Sooper !!
it worked !!
Thanks a lot
hi,
If use following expression
Dual(if(RowName='',' ',RowName),ID) AS DB_Name.
it is working with Dual
for time being you can use the above function.
WOW it worked too
thanks dude