topic Re: multi condition in field in QlikView

multi condition in field

omid5ive — Sat, 05 Nov 2016 12:21:23 GMT

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/1/1996

2/2/1996

5/2/1996

8/8/1996

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

Re: multi condition in field

robert_mika — Sat, 05 Nov 2016 21:05:51 GMT

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)

Re: multi condition in field

omid5ive — Sun, 06 Nov 2016 05:45:55 GMT

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

Re: multi condition in field

robert_mika — Sun, 06 Nov 2016 05:51:21 GMT

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?

Re: multi condition in field

omid5ive — Sun, 06 Nov 2016 06:20:09 GMT

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