Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all...
My users have this kind of report (image attached)
and they want Qlikview to show the report exactly like that
Currently I use multiple textboxes to develop it. but i have a problem when i need to export the report to excel.
My questions are:
1. is there any way to export all the values of those text objects to every cell in excel? probably using macro or whatever it is. please kindly explain how
2. is there another alternative (other than using multiple textboxes) to present the report exactly as the image above? I would like to try to customize the straight table but the dimensions are not present in any table. So I have to create them explicitly. What is the best way to do it? Also explain how.
Thanks for your help!
+ tamilarasu
pfa
Peter
hi pete
Thank you that's a great example
Could you tell me how to add new rows right under 'c. FCT'
Because I tried it and it didnt appear on the table
Hello, Mike!
In that unusual case you can use a variable which will store all values of your textboxes separated with ";" or other symbol. And all you'll have to do is copy value of this variable in excel and use text by columns option.
hey I figured it out
Thank you
You should add any Line (even blanks with ' ') into the "Report"-Table.
And then each expression must consider this line within the PICK-statement, e.g. analogue to the first expression
PICK(Component,
' ',
SUM( {$ <DetailComponent = {a} >} Val),
Where the Line 02 indicates an empty row
Peter
Hi Mike,
Have a look at the below link.
Need Macro to export multiple text-boxes into single excel sheet