Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have been currently working on a sales table with some key algorithms
Data Source | |||
Date | Brand | Status | Salesman |
1/1/2018 | A | 0 | S |
1/2/2018 | A | 0 | S |
1/3/2018 | B | 1 | S |
1/4/2018 | B | 0 | S |
1/5/2018 | B | 1 | S |
1/1/2018 | A | 1 | j |
1/2/2018 | A | 0 | j |
1/3/2018 | B | 0 | j |
1/4/2018 | B | 0 | j |
1/5/2018 | B | 0 | j |
In the data set above.the sales manager has a desire to see only the status '1' for each salesman and brand in the selected period. If the sales manager selects a period from 1/1/2018 to 1/5/2018,
Table becomes
Start Date | 1/1/2018 | End Date | 1/5/2018 |
Brand | ||
Salesman | A | B |
S | 0 | 1 |
J | 1 | 0 |
and when he selects 1/1/2018 to 1/1/2018
The table becomes
Start Date | 1/1/2018 | End Date | 1/1/2018 |
Brand | |||
Salesman | A | B | |
S | 0 | 0 | |
J | 1 | 0 |
Can you kindly share your thoughts?
This should be the out of the box behaviour of a pivot table in Qlik. This can be by the user selecting Status = 1, or using it in a set expression like Status = {1}. Use Salesman, Brand as dimensions and Count({<Status = {1}>} Brand) as the expression.
in the expression just pass this expression
if( Status= 1, Status)
if u dont want status to be printed then
if( Status= 1, 'Pas') that means in front of a and b when status =1 then Pass will be printed