topic Re: Adding a New Column in QlikView

Adding a New Column

Mon, 30 Dec 2013 06:13:27 GMT

Hi Everyone,

I have 3 columns A, B and C in my table, Now I need to create another column D, where D=(A+B+C)* n where n can range from 1 to 10.

I want to show all these four columns on my dashboard and just by selecting value of n in slider I will have the required table on dashboard.

If there is any video available on you tube, kindly provide the link.

Thanks in Advance !!

Regards

Anjana

Re: Adding a New Column

Anonymous — Mon, 30 Dec 2013 06:18:33 GMT

Hi Anjana,

In Script reload your table with all A,B,C columns.

Now create a variable as vInput and provide min and max values as 1 and 10 respectively.

Create a slider and assign vInput to it.

Now create a straight table with A,B,C as Dimension and a expression as:

(sum(A+B+c))*vInput.

Now when you wil slide you vInput values, the chart will reflect accordingly..

Hope this helps you.

regards

Nitin

Re: Adding a New Column

bbi_mba_76 — Mon, 30 Dec 2013 06:21:28 GMT

Hi,

you have to create a chart, select straight table in the general tab, add the 3 dimensions, A,B,C and then in the expression tab =(A+B+C)*n

Create the variable n (Settings > variable overview) and then the slider object, in which you select the variable n.

Re: Adding a New Column

sujeetsingh — Mon, 30 Dec 2013 06:32:45 GMT

Anjana , please have a look on this sample .

Re: Adding a New Column

Mon, 30 Dec 2013 06:37:24 GMT

Hi,

I am able to create this variable n but When I create this straight table, there are only columns heading but no values under Heading A,B C and D.

Kindly help !!

Anjana

Re: Adding a New Column

sujeetsingh — Mon, 30 Dec 2013 06:44:41 GMT

Miss!

have a look on the sample i have just given in my comment .

To create a variable just go to Settings>>DocumentProperties>>Variables Tab>>

And then add new variable and name .

Now call it in the slider object

Re: Adding a New Column

Mon, 30 Dec 2013 06:52:07 GMT

Hi Everyone,

Thanks for the help.

I am Know able to create the required table.

Wish you all a happy New Year

Thanks once again !!!

Anjana

Re: Adding a New Column

sujeetsingh — Mon, 30 Dec 2013 08:22:45 GMT

A very Happy New Year to you MISS!!

Are not able to see the comment of mine with a sample attached .

Hope you get some help from it.