Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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],
F6
as [PRICE 2],
F7
as [PRICE 3],
F8
as[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.
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.
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
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],
F6
as [PRICE 2],
F7
as [PRICE 3],
F8
as[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.
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],
F6
as [PRICE 2],
F7
as [PRICE 3],
F8
as[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.
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
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 ??
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 ?
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?
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.