multi condition in field

[omid5ive]

hi

i have table like below:

level	package	date
1	a	1/1/1996
2	a	2/2/1996
1	b	5/2/1996
4	b	8/8/1996
5	c	9/5/1966
6	c	4/12/1996

now i want to create pivot table like below:

package	level	1	2	3	4	5	6
a		1/1/1996	2/2/1996
b		5/2/1996			8/8/1996
c						9/5/1966	4/12/1996

i have no problem for this but i want to have some availability for end user that can create condition for each level
for example he can see records for level 1 that the date is bigger than 1/1/1996 and record of level 2 that smaller than 2/2/1996 and ...

i want to show all of them in single pivot table
in this sample :level and package both of them is dimension and the expression is date

how can i handle this problem

[robert_mika]

You can conditionally hide the column

and then use Background color to show/hide values for each of the columns.

But that will create very long conditional statement.

Imagine someone wants 5 levels of data with two different criteria...

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[omid5ive]

no

i dont want to select level

i want to select date
i need to have condition on my date value

for example:

i want to see 1/1/1996 for level 1 and 8/8/1996 for level 4

[robert_mika]

You indicated:

create condition for each level

Do you want the condition for each level or for all level but with to change the date range?

[omid5ive]

i want to have condition on each value of level
for example i want to see table with all level but for level a set some condition and for b level set another condition and so on