Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display dynamic straight table?

hi ,

Hi,

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

see my data

1.PNG

2.PNG

step1: I select pivot table

3.PNG

Step2: I take 2 dimensions

8.PNG

Step 3: I write expression in expression tab.

4.PNG

5.PNG

Step 4: I take this data

6.PNG

but when I select month in list box I doesnot work. see this image.

7.PNG

I want to display straight table like below

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

Listbox
Jan
Feb
Mar
apr
may
jun

Straight table.

CountryJanFebmar
India120001500020000
Uk150002000025000
Aus200002500030000

If I select  Feb  in list box.

List box
Jan
Feb
Mar
apr
may
jun

Then straight table  display like below.

countryJanFeb
India1200015000
Uk1500020000
aus2000025000

pls tell me  out how to display data like above.

                                       

                                                                   Thankyou,

Regards

madhu

0 Replies