topic HOW TO TOGGLE CHARTS ? in QlikView

HOW TO TOGGLE CHARTS ?

Fri, 08 Apr 2011 03:46:30 GMT

I have 4 Chart Tables with varios data. I need to make all this into 1, by toggling them. So lets say i have 4 Charts tables named

1)SONY

2)DELL

3)APPLE

4)PANASONIC

I have to toggle all 4 of them with maybe a button, so there would be a button saying, " CLICK FOR DELL" or "CLICK FOR APPLE" or "CLICK FOR PANASONIC. ( IF MY INTIAL SELECT WAS AT SONY).

How do you go about doing this? I added a recent post on how to toggle input boxes, i used the same apporach, but it did not work.

Please do try this out!

Thanks! =D

HOW TO TOGGLE CHARTS ?

deepakk — Fri, 08 Apr 2011 05:17:11 GMT

hi,

I would suggest you to use list box instead of buttons and use one chart instead of four.

I have attach a sample file. I hope this helps you out.

HOW TO TOGGLE CHARTS ?

Fri, 08 Apr 2011 06:52:03 GMT

Hi Deepak! Thanks for your suggestion, but that is not what i wanted, take a look at the sample file i made, i think it would be quite clear on what i want.

Basically, i am just using one excel file, but it opens out to 4 different price lists.

I need a way to toggle those 4 Price list Charts.

The qlikview file would be more useful in understand the situation.

For reference, please do check out my previous post on 'HOW TO TOGGLE INPUT BOXES". That solution might help.

An suggestions?

Thanks! =D

HOW TO TOGGLE CHARTS ?

deepakk — Fri, 08 Apr 2011 07:11:56 GMT

hi,

Sorry I didnt get a clear picture...

What i understand is , you need four buttons for the four field price1, price 2.

when every you select price1 you will get data for price1.. right ??

If yes you can covert the data into row format using cross table.

so your code would be

crosstable

(Price,Amount,3)

LOAD

Description as DESC

[HMS Product type]

as [PRODUCT_TYPE]

[HMS Order]

as [PART_NO.]

[Price in EUR]

as [PRICE 1]

as [PRICE 2]

as [PRICE 3]

[PRICE 4]

// Description1,

// [HMS Product type1],

// [HMS Order1],

// [Price in EUR1]

FROM

C:\QPRICE\SAMPLES\Sample_Charts.xls

(

biff, embedded labels, table is Embedded$)

;

Now in Fron end you will get a field called as Price which will contain data like Price 1,price 2 etc

once you select data on Price1 you will get respective data from Value field.

HOW TO TOGGLE CHARTS ?

deepakk — Fri, 08 Apr 2011 07:11:59 GMT

hi,

Sorry I didnt get a clear picture...

What i understand is , you need four buttons for the four field price1, price 2.

when every you select price1 you will get data for price1.. right ??

If yes you can covert the data into row format using cross table.

so your code would be

crosstable

(Price,Amount,3)

LOAD

Description as DESC

[HMS Product type]

as [PRODUCT_TYPE]

[HMS Order]

as [PART_NO.]

[Price in EUR]

as [PRICE 1]

as [PRICE 2]

as [PRICE 3]

[PRICE 4]

// Description1,

// [HMS Product type1],

// [HMS Order1],

// [Price in EUR1]

FROM

C:\QPRICE\SAMPLES\Sample_Charts.xls

(

biff, embedded labels, table is Embedded$)

;

Now in Fron end you will get a field called as Price which will contain data like Price 1,price 2 etc

once you select data on Price1 you will get respective data from Value field.

HOW TO TOGGLE CHARTS ?

Anonymous — Mon, 11 Apr 2011 01:41:58 GMT

I think what you are looking for is a container. Create a Container Object from New Sheet Objects. In the General Tab, add the 4 "Existing Objects" that you want to include (Sony, Dell, etc.) into the Container. Then you can choose the location of the buttons used for toggling in the Presentation Tab in the dropdown Appearance list.

Best, Mike

HOW TO TOGGLE CHARTS ?

Tue, 12 Apr 2011 02:38:31 GMT

Hi Deepak!

Thanks for that answer, it was really helpful! One question though, in the first statement,

Crosstable

(Price,Amount, 3)

What does the 3 stand for ??

HOW TO TOGGLE CHARTS ?

Tue, 12 Apr 2011 03:06:52 GMT

Hi Mike! Thanks for your solution, but i'm afraid i'm not using your version of qlikview.

I'm guessing you are using qlikview version 10 ?

HOW TO TOGGLE CHARTS ?

Tue, 12 Apr 2011 03:09:17 GMT

Oh wait, i think i understand,

crosstable

(Price, Amount, 3)

Am i right to say that, the variable "3", comments the first 3 lines of my loadscript, so that i can start from the 4 prices?

HOW TO TOGGLE CHARTS ?

deepakk — Tue, 12 Apr 2011 04:33:48 GMT

Yes you are right.

WHen ever you have data in column fomat and you want to convert into row format, we use Crosstable. the no 3 indicates after the 3 the data need to be converted in rows.

HOW TO TOGGLE CHARTS ?

Tue, 12 Apr 2011 04:41:12 GMT

Thanks Deepak!

The statement you gave was,

Crosstable

(Price, Amount, 3)

So, crosstable applies for only 3 variables? or can we add more if we want to ?

HOW TO TOGGLE CHARTS ?

deepakk — Tue, 12 Apr 2011 04:44:39 GMT

hi,

It Means after 3rd field convert all other fields to row format.

Crosstable(Data,Value , 2)

Load a,b,c,d from table

This will covert c and d field into row.

HOW TO TOGGLE CHARTS ?

Tue, 12 Apr 2011 04:58:09 GMT

Hi Deepak.

Okay, so if,

(Data,Value,3)

Load A,B,C,D,E,F,G from table.

Convert D,E,F,G field into row.

And if,

(Data,Value, 5)

Load A,B,C,D,E,F,G

Convert F and G field into row. Is that right?

So the trick about using crosstable is the Number variable at the back, because it comments the amount of lines it is put as.

And Data would be the heading of the List Box created. And Value would be A,B,C,D,E,F,G.

Thats pretty cool! Thanks Deepak! =D