topic Re: Formatting in Fast Change in QlikView

Formatting in Fast Change

Mon, 06 May 2013 07:45:18 GMT

Hi All,

I have a chart with fast change option enabled, it shows a bar chart and a straight table.

Now, for bar chart I want to display the value of Spend as a formatted one like 183.6 M (M for Million, K etc.).

And when it is fast changed to straight table, Spend should display as 183,619,992.30

Is this possible to implement!

I have attached the images of both the charts.

Thanks,

Manisha Choudhary

Re: Formatting in Fast Change

Gysbert_Wassenaar — Mon, 06 May 2013 08:03:48 GMT

Yes, see attached example.

Re: Formatting in Fast Change

Mon, 06 May 2013 08:41:54 GMT

Hi Gysbert,

Thanks for the quick reply.

But I am getting the formatted expression also (Please see image attached)

Is there any option which I am missing or any conditional expression!

Thanks,

Manisha Choudhary

Re: Formatting in Fast Change

Mon, 06 May 2013 08:46:14 GMT

Working now. Need to hide the column

Thanks a lot

Re: Formatting in Fast Change

Fri, 13 Dec 2013 10:05:46 GMT

Hi Gysbert Wassenaar,

Could you tell the procedure for the requirement,

Since I'm using personal edition, so I can't open the qvw file.

Thanks in Advance.

Regards,

Pavan.

Re: Formatting in Fast Change

Fri, 31 Jan 2014 15:58:55 GMT

Manisha,

Could you explain how you were able to hide the column? I downloaded the example, but when I try to implement it, I get 2 expression columns in the straight chart. I can't figure out what setting will hide the expression that is used in the bar chart.

Thanks,

Kathy