Hey i need help in the syntax

[#1]

Modified:

crosstable (Share, Values, 6)

LOAD 

`bot_entity_id`,

    `bot_entity_name`,

    `channel_id`,

    `geo_id`,

    Identifier,

    `REGION_ID`,

   * Inline [ `Share_1`,

    `Share_10`,

    `Share_11`,

    `Share_12`,

    `Share_13`,

    `Share_14`,

    `Share_15`,

    `Share_16`,

    `Share_17`,

    `Share_18`,

    `Share_19`,

    `Share_2`,

    `Share_20`,

    `Share_21`,

    `Share_22`,

    `Share_23`,

    `Share_24`,

    `Share_3`,

    `Share_4`,

    `Share_5`,

    `Share_6`,

    `Share_7`,

    `Share_8`,

    `Share_9`,]

    `Share_Ind_reg1`,

    `Share_Ind_reg10`,

    `Share_Ind_reg11`,

    `Share_Ind_reg12`,

    `Share_Ind_reg13`,

    `Share_Ind_reg14`,

    `Share_Ind_reg15`,

    `Share_Ind_reg16`,

    `Share_Ind_reg17`,

    `Share_Ind_reg18`,

    `Share_Ind_reg19`,

    `Share_Ind_reg2`,

    `Share_Ind_reg20`,

    `Share_Ind_reg21`,

    `Share_Ind_reg22`,

    `Share_Ind_reg23`,

    `Share_Ind_reg24`,

    `Share_Ind_reg3`,

    `Share_Ind_reg4`,

    `Share_Ind_reg5`,

    `Share_Ind_reg6`,

    `Share_Ind_reg7`,

    `Share_Ind_reg8`,

    `Share_Ind_reg9`,

    `SUB_MARKET`;

SQL SELECT *

FROM `Modified`;

i only want to transpose the columns( share_24 -to- share_1) and there values. kindly let me know the error in this syntax.

Thanks in advance.

Regards

Sagar

[deepakk]

hi Sagar,

I don't think this is the right approach. You can't use Load inline and sql together.

Below willl be the right method.

crosstable(Data,Value,7)

Load

`bot_entity_id`,

    `bot_entity_name`,

    `channel_id`,

    `geo_id`,

    Identifier,

     SUB_MARKET`;

    `REGION_ID`,

    `Share_10`,

    `Share_11`,

    `Share_12`,

    `Share_13`,

    `Share_14`,

    `Share_15`,

    `Share_16`,

    `Share_17`,

    `Share_18`,

    `Share_19`,

    `Share_2`,

    `Share_20`,

    `Share_21`,

    `Share_22`,

    `Share_23`,

    `Share_24`,

    `Share_3`,

    `Share_4`,

    `Share_5`,

    `Share_6`,

    `Share_7`,

    `Share_8`,

    `Share_9`,]

    `Share_Ind_reg1`,

    `Share_Ind_reg10`,

    `Share_Ind_reg11`,

    `Share_Ind_reg12`,

    `Share_Ind_reg13`,

    `Share_Ind_reg14`,

    `Share_Ind_reg15`,

    `Share_Ind_reg16`,

    `Share_Ind_reg17`,

    `Share_Ind_reg18`,

    `Share_Ind_reg19`,

    `Share_Ind_reg2`,

    `Share_Ind_reg20`,

    `Share_Ind_reg21`,

    `Share_Ind_reg22`,

    `Share_Ind_reg23`,

    `Share_Ind_reg24`,

    `Share_Ind_reg3`,

    `Share_Ind_reg4`,

    `Share_Ind_reg5`,

    `Share_Ind_reg6`,

    `Share_Ind_reg7`,

    `Share_Ind_reg8`,

    `Share_Ind_reg9`,

    `SUB_MARKET`;

SQL SELECT *

FROM `Modified`;

Add the transforming data in the end and specify the end point of the field for which you dont need the transformation in the crosstable command.

I hope you got my point.

Deepak

[#3]

Hi Deepak

Dude thanks for your reply but i am still facing problem in running the syntax.

Regards

Sagar Gupta

[deepakk]

Hi Sagar,

Above code had some syntax error.. i have rectified in the below code

crosstable(Data,Value,7)

Load

`bot_entity_id`,

    `bot_entity_name`,

    `channel_id`,

    `geo_id`,

    Identifier,

     SUB_MARKET,

    `REGION_ID`,

    `Share_10`,

    `Share_11`,

    `Share_12`,

    `Share_13`,

    `Share_14`,

    `Share_15`,

    `Share_16`,

    `Share_17`,

    `Share_18`,

    `Share_19`,

    `Share_2`,

    `Share_20`,

    `Share_21`,

    `Share_22`,

    `Share_23`,

    `Share_24`,

    `Share_3`,

    `Share_4`,

    `Share_5`,

    `Share_6`,

    `Share_7`,

    `Share_8`,

    `Share_9`,

    `Share_Ind_reg1`,

    `Share_Ind_reg10`,

    `Share_Ind_reg11`,

    `Share_Ind_reg12`,

    `Share_Ind_reg13`,

    `Share_Ind_reg14`,

    `Share_Ind_reg15`,

    `Share_Ind_reg16`,

    `Share_Ind_reg17`,

    `Share_Ind_reg18`,

    `Share_Ind_reg19`,

    `Share_Ind_reg2`,

    `Share_Ind_reg20`,

    `Share_Ind_reg21`,

    `Share_Ind_reg22`,

    `Share_Ind_reg23`,

    `Share_Ind_reg24`,

    `Share_Ind_reg3`,

    `Share_Ind_reg4`,

    `Share_Ind_reg5`,

    `Share_Ind_reg6`,

    `Share_Ind_reg7`,

    `Share_Ind_reg8`,

    `Share_Ind_reg9`,

    `SUB_MARKET`;

SQL SELECT *

FROM `Modified`;

Deepak

[#5]

Thanks Deepak

I made my bar_chart animated and now I want my bars to leave a mark when they reach its maximun. Do you have any idea how to do that.

Regards

Sagar Gupta

[deepakk]

hi Sagar,

Next to expression... there is plus sign. click on it .. you will see background, text etc..

click on background and on right side  write ur expression.

If (Value < 10, green(),red())

Deepak

[Anonymous]

Hi

     Give some sample files to understand your problem easily

Regards

[#8]

Hi Deepak and Chandashok

What i am looking for is--- my X-axis has values from 0 to 100, and when my bar reaches the maximum point on X-axis i should get a small horizontal line. As my bar chart is animated so it will move from 0 and then reaches its maximum value (for particular field on Y-axis) and then again comes back to 0. Let me know if this option is available in QV.

Are you guys getting my problem?

Regards

Sagar Gupta

[deepakk]

Hi,

Use a combo chart option. and add another expression which will be like..

Sum(If(value >100, value))....  and make this as line...

so when ever your bar reached above 100 this will be displayed..

Deepak