Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to display dynamic straight table ?

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.

CountryJanFebmar
India120001500020000
Uk150002000025000
Aus200002500030000

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

countryJanFeb
India1200015000
Uk1500020000
aus2000025000

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

23 Replies

Re: How to display dynamic straight table ?

Hi,

please explain, how your straight table shows month field values in columns?

Do you have seperate expressions (per month) or did you mean a pivot table instead of a straight table?

thanks

regards

Marco

MVP
MVP

Re: How to display dynamic straight table ?

see attached .qvw

Not applicable

Re: How to display dynamic straight table ?

Thank you Massimo grossi.

Not applicable

Re: How to display dynamic straight table ?

I use personal edition .I can not open your attached qvw pls send screen shots or explain with small example .

Regards

madhu

Re: How to display dynamic straight table ?

Do you want something like the attached? (PFA)

Best,

Sunny

Re: How to display dynamic straight table ?

Since you use personal edition try this:

Script used:

Table:

LOAD * Inline [

Country, Month, Value

India, Jan, 12000

India, Feb, 15000

India, Mar, 20000

UK, Jan, 15000

UK, Feb, 20000

UK, Mar, 25000

Aus, Jan, 20000

Aus, Feb, 25000

Aus, Mar, 30000

];

Straight Table with

Dimension: Country

Expression: 1) =Sum({<Month = {'Jan'}>} Value)

                  2) =Sum({<Month = {'Feb'}>} Value)

                  3) =Sum({<Month = {'Mar'}>} Value)

With hide and show condition for the expressions

Expression: 1) =SubStringCount(Concat(DISTINCT Month, '|'), 'Jan') = 1 or

                        SubStringCount(Concat(DISTINCT Month, '|'), 'Feb') = 1 or

                        SubStringCount(Concat(DISTINCT Month, '|'), 'Mar') = 1

                  2) =SubStringCount(Concat(DISTINCT Month, '|'), 'Feb') = 1 or

                        SubStringCount(Concat(DISTINCT Month, '|'), 'Mar') = 1

                  3) =SubStringCount(Concat(DISTINCT Month, '|'), 'Mar') = 1

Image of where they need to go:

Capture.PNG

I hope this helps.

Best,

Sunny

MVP
MVP

Re: How to display dynamic straight table ?


Replace my dim (product) with your (country) and MonthNames



SET DateFormat='DD/MM/YYYY';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

a: load

  pick(match(floor(rand()*6+1),1,2,3,4,5,6),'car','bike','bus','plane','train','boat') as product,

  'T' & ceil(month(d)/3) as q,

  year(d) as y,

  date(d) as d,

  dual(month(d), num(month(d))) as m,

  v;

load

  floor(today() -1000 + rand()*2000) as d,

  rand()*100-rand()*100 as v

AutoGenerate 10000;

 

1.png

Not applicable

Re: How to display dynamic straight table ?

Thankyou marco wedel.I take year 2001 and months jan, feb,march,apr,may. and I wrote expression in conditional box in expression tab like this.

=wildmatch(concat(month,'/')'jan')

=wildmatch(concat(month,'/')'feb')

=wildmatch(concat(month,'/')'mar')

=wildmatch(concat(month,'/')'apr')

when I select year 2001 and month jan I works correctly.but when I select  year 2001 and  months:jan,feb,march that time I does not display months(it does not work properly) pls tell me out .how to display straight table based on selections  pls help me Marco wedel.

Regards

madhu

Not applicable

Re: How to display dynamic straight table ?

Thankyou sunindia.

Community Browser