Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

Dear Friends!

I have a Table with Number of Employees   ( in each Department)

I have  Years and Months!

i need to show  number of employees  month wise  in a straight table

but on my selection

if i select  year  2015 it should show  numbers of employees in  jan , feb , march April and may

if i select year  2015 and month  jan and march  ... i need  the data of selection

any idea please share

thanks

tahir

1 Solution

Accepted Solutions
MVP
MVP

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

Hi,

Check this link hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

5 Replies

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

Is Year and Month your dimension or are you creating different expressions for each month and year? If they are dimension, they should automatically reduce to your selection. If they are not then you can keep some restrictive conditions on each of the expression (but having them as expressions wouldn't make too much sense). Would you be able to share some sample here?

Not applicable

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

no in my dimention i put  department

and in expression i have  year and month

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

You should be able to restrict each of your expression based on a selection with something like this:

For a Jan 2015 expression you can use a conditional hide/show condition like this:

SubStringCount(Concat(Month, ','), 'Jan') = 1 and SubStringCount(Concat(Year, ','), '2015') = 1

For more details on this topic, you might find this link to be useful: Customizable Straight Table

HTH

Best,

Sunny

MVP
MVP

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

Hi,

Check this link hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: DYNAMIC STRAIGHT TABLE WITH SELECTED FIELDS

‌Can you put month and year as dimensions?

Community Browser