Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
|
| |||||||
b |
|
| |||||||
c |
|
|
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
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?
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
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?
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