topic Hey i need help in the syntax in QlikView

Hey i need help in the syntax

Mon, 05 Mar 2012 05:15:13 GMT

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

Hey i need help in the syntax

deepakk — Mon, 05 Mar 2012 06:06:47 GMT

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

Hey i need help in the syntax

Mon, 05 Mar 2012 06:40:05 GMT

Hi Deepak

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

Regards

Sagar Gupta

Hey i need help in the syntax

deepakk — Mon, 05 Mar 2012 06:51:38 GMT

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

Hey i need help in the syntax

Mon, 05 Mar 2012 08:35:35 GMT

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

Hey i need help in the syntax

deepakk — Mon, 05 Mar 2012 11:16:24 GMT

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

Hey i need help in the syntax

Anonymous — Mon, 05 Mar 2012 11:18:59 GMT

Give some sample files to understand your problem easily

Regards

Hey i need help in the syntax

Mon, 05 Mar 2012 11:53:48 GMT

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

Hey i need help in the syntax

deepakk — Mon, 05 Mar 2012 11:57:10 GMT

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