uploading different type of data in one column

[raghavsurya]

Hi All,

We have a situation wherein we have multiple details of a cost center performance.  The values for performance measures are different for each measure.  For example it has date, percentages, number etc.

Performance measure               Actual       Budget

1. Revenue                                  20K          22K

2. Customer Satisfaction               80%         95%

3. Start date                                01-Apr-11   01-Apr-11

and so on.  In my upload script I have tried to put this code

if(istext(Actual),text(Actual),if(left(text(Actual),3)='*/',date(Actual),Actual)) as Actual,
if(istext(Budget),text(Budget),if(left(text(Budget),3)='*/',date(Budget),Budget)) as Budget

when I am pulling the data in qlikview and putting it in a straight table chart, customer satisfaction is appearing as .80 and not as 80%.  Am I missing any trick here.  Can anyone pls suggest.

Regards,

Raghav

[its_anandrjs]

Hi,

You have to change settings of the .80 value to 80% so go to straight chart properties

Properties -> Number tab -> Select Expression -> Select Fixed 2 Decimals and select show in Percent -> and check format should be #.##0,00%

and reset of the code is ok try this

HTH

Rgds

Anand

[raghavsurya]

Hi Anand,  Since I have other values which are not to be shown in percentages, I can't use this option.  If I use even revenue will be depicted in %.    Regards,

[jonathandienst]

Hi

Would it not be better in this case to transpose the data, so that the columns represent Revenue, Customer Satisfaction etc, and rows for actual and budget?

Regards

Jonathan

[kaushiknsolanki]

Hi,

   I have tried something and i would like you to  have a look at it.

   Let me know if it solves your problem of not.

Regards,

Kaushik Solanki

[raghavsurya]

Hi Kaushik,  My situation is little bit complicated.  Since I have multiple lines linked to date, I need to put in an expression to get the latest value.  I have attached a sample file for your kind reference.  Pls share your thoughts.

Regards,

Raghav

[#7]

Hi,

Why dont u treat everything as text.

or

Try this

if(istext(Actual),text(Actual),if(left(text(Actual),3)='*/',date(Actual),Actual),text(Actual)) as Actual,
if(istext(Budget),text(Budget),if(left(text(Budget),3)='*/',date(Budget),Budget),text(Budget)) as Budget

[kaushiknsolanki]

Hi,

    Can you please tell me with example what output you are expecting.

Regards,

Kaushik Solanki

[raghavsurya]

Hi Kaushik,  PFB sample output.  I would like to do something like this.

Particulars	Previous Month	Current Month	Trend
Admissions	2422	2483
Treatment   Compliance	79%	74%
Bed Occupancy	8 mins	8 mins
Average   Process Delay	3 days	2 days
Average Length   of Stay	63%	69%
Bed   utilization rate	4.5 Hours	5.2 Hours

Thanks and Regards,Raghav

[kaushiknsolanki]

Hi,

     If you can send me the excel file, it would help me to try something new on it.

Regards,

Kaushik Solanki