Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading data from an xls. It has one column known as 'DIFF'. This column has percent as well as integer values. For example, it has values as follows:
DIFF
20%
0
1
50%
When I load this data into Qlikview, all the values are converted to percentages by Qlikview while loading. So, value 0 is converted to 0% and 1 to 100%, instead of the original values of 0 and 1 respectively.
Please let me know, how can I display the actual values, that is i want to show the both the percent and integer values in this column. Pls. guide.
Hi Ravi,
Seems to be working in your case, but in my case its still the same.. .
Attaching the qvw file for your reference. See that I still have all the % values, instead of the original values.
Pls. let me know if I have made any mistake at my end.
Regards,
Swati
take data type text
Eg load
text(DIFF)
resident abc;
Regards
Ashish Srivastava
Hi Ashish, Thanks for replying.
I tried loading the column data using text(DIFF) but that converts all the column values to integer values.
But I want to show percent values as percent and integer values as integers, that is, I want to show actual values, intead of converting them to a specific type.
Regards,
Swati
Dear Swati
What is your data source ?.
Regards
Ashish Srivastava
Hi Swati,
There is no need to apply any specific syntax, function to your source database.
Refer to attachment.
In pivot table chart properties, Number section, keep "Expression Default" clicked.
Hope this answers your query.
Sincere Regards,
Happy Thoughts
My data source is an excel file, and I am importing data from that xls.
text(DIFF) works for me. Can you post your xls file?
-Rob
Hi Ravi,
Thanks for replying.
I have not used any function to convert data to any particular format. Qlikview automatically converts all integer values to % also.
I also have "Expression Default" selected in the Number tab of the chart properties, still this conversion has taken place.
I think the difference might be the source of data being loaded into Qlikview. You are loadiing inline data whereas I am loading data from an excel file.
Please see if you get correct results after laoding data from an excel file.
Regards,
Swati
Hi Swati,
I have first done it by sourcing data from Excel file and then I loaded inline data for your convenience..
In Excel file, make sure that cells where you have % value have % Number format.
Also, this can be verified by creating list box of Values in QV.
Just try it.
Sincere Regards,
Happy Thoughts
Hi Rob,
Please find attached the xls file. Refer to the 'DIFF' column at the end of the xls file, which has both percent and integer values.
Regards,
Swati