How to display dynamic straight table ?

[#1]

Hi,

I create straight table in qlikview . I want to display my straight table  dynamically according to my selections. like this

If I select march then display my straight table Jan feb mar.like below.

Listbox
Jan
Feb
Mar
apr
may
jun

Straight table.

Country	Jan	Feb	mar
India	12000	15000	20000
Uk	15000	20000	25000
Aus	20000	25000	30000

If I select  Feb then display Like this :it show only jan and feb .

country	Jan	Feb
India	12000	15000
Uk	15000	20000
aus	20000	25000

I wrote condition like this =WildMatch(Concat(month,'/'),'Jan') but It does not work. pls tell me out how display straight table like above

                                                              Thankyou,

Regards

madhu

[MarcoWedel]

Hi,

now you are loading the Months twice.

One time as text and another time as dual values.

Try with

LOAD Year,
     Month(Date#(month,'MMM')) as Month
FROM [C:\Users ...

hope this helps

regards

Marco

[#3]

Thank you Marco wedel for your support Marco wedel .Thanks a lot.

[#4]

Hello Marco wedel. pls can you send your script information plss .I tried my level best It is not work to me.

                  pls send script inforamation.

                                                                            Thank you,

Regards

madhu

[#5]

hello marco wedel

Step 1: when I select jan it dispaly jan as it is I  select feb It dispaly feb But when i select jan feb I  did not work to me .

Step 2:I select feb  it display feb.

step 3: I select Jan and feb I display Like below.but I want to display data according to my selections pls help me.

                                           Thankyou,

Regards

madhu