Dual function qlikview not working

[#1]

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

[#2]

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

[MayilVahanan · Accepted solution]

Hi

Use straight table to solve your problem. PFA, refer sheet2

[#4]

Sooper !!

it worked !!

Thanks a lot

[#5]

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.

[#6]

WOW it worked too

thanks dude