topic Re: Straight table to pie chart in QlikView

Straight table to pie chart

Mon, 24 Mar 2014 09:17:29 GMT

Hello guys!

I have a straight table that looked like this

With the [Document Date] and [Posting Group] being the dimensions while [Outstanding Amount (LCY)] is the expression express like the following

=IF([Document Date]>=MIN(CDate) and [Document Date]<=MAX(CDate),SUM([Outstanding Amount (LCY)]))

So you might already be able to guess that the straight table above will display data based on selected value i.e. currently selected year 2014. The problem is that when I change the table to pie chart using the same dimensions and expession the pie chart would looked like this:

My question is : What can be done so that the pie chart would only show the [Posting Group] slices and the slices, like the straight table will change based on selected value (say if you select year 2014 from a list box). I tried removing the [Document Date] from the dimension so that it will only have the [Posting Group] as the dimension and [Outstanding Amount (LCY)] is the expression express like the one in the straight table which is =IF([Document Date]>=MIN(CDate) and [Document Date]<=MAX(CDate),SUM([Outstanding Amount (LCY)])) but it didn't display any data.

Any suggestions and opinions would greatly appreciated.

Thank you for you kind attention guys!

Re: Straight table to pie chart

MK_QSL — Mon, 24 Mar 2014 09:26:13 GMT

You can create two different objects as per your requirements.. 1) Straight Table 2) Pie Chart

Use Conditional Show under Layout Tab to show them...

i.e. Create a Variable vSHOW = 1

Now Create a Button

Go to action tab >> ADD >> External >> Set Variable

Variable : vSHOW

Value : if(vSHOW = 1, 0,1)

Straight Table >> Layout >> Conditional Show >> vSHOW = 1

Pie Char >> Layout >> Conditional Show >> vSHOW = 0

Hope this helps..

Re: Straight table to pie chart

Mon, 24 Mar 2014 09:32:26 GMT

Hello Manish Kachhia.

Erm, from my understanding that is to show/hide objects right? My problem is that I'm trying to convert the given straight table to a pie chart. But instead showing of the [Posting Date] slices in the pie chart, I want it to only show [Posting Group] slices but selecting say a value i.e Year from a listbox would populate the pie chart slices accordingly as in the straight table.

Thank you very much for your kind attention

Re: Straight table to pie chart

MK_QSL — Mon, 24 Mar 2014 09:36:43 GMT

Don't know whether this could be possible in fast type change.

May be someone can provide better solution.

Re: Straight table to pie chart

sunilkumarqv — Mon, 24 Mar 2014 09:47:50 GMT

In straight table you used date as Dimension ,copy the same chart then eliminate date in dimension then you can use show and hide options .

Re: Straight table to pie chart

Mon, 24 Mar 2014 09:53:39 GMT

Guys.

Well actually this is what I want to have

The pie no longer show [Posting Date] slices even though the posting date is part of the dimension of the pie chart

Re: Straight table to pie chart

sunilkumarqv — Mon, 24 Mar 2014 09:57:37 GMT

can you share sample one

Re: Re: Straight table to pie chart

Wed, 26 Mar 2014 03:41:22 GMT

Hello Sunil Kumar,

Attached is a sample file.

Thank you for your kind attention

Re: Straight table to pie chart

Anonymous — Sun, 05 Jul 2015 12:28:33 GMT

I think I got your problem,you just want to show the pie chart with the contribution of these 4 departments?is that correct?

If yes, then if([Gen_ Prod_ Posting Group]='GOODS','SALES',[Gen_ Prod_ Posting Group]) as department

this goes in the backend reload it and in the dimension take this department with the same expression and I think you'll get what you expect...

Does that help?