Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm building a Qlikview with a lot off charts; There are 4 different charts for every combination of Product and Outsourcer.
I look for a way to use fewer variables
The variables are:
varHJ_Outsourcer1a => Outsourcer number (modifiable by client with input box)
varHJ_Outsourcer1a_Order => COUNT(DISTINCT{<flgOrderregelInProductie={'1'}, Product = {'HJ'}, Outsourcer1 = {$(varHJ_Outsourcer1a)}>}Ordernumber)
varHJ_Outsourcer1a_Product => sum({<flgOrderregelInProductie={'1'}, Product = {'HJ'}, Outsourcer1 = {$(varHJ_Outsourcer1a)}>} number)
varHJ_Outsourcer1a_Backorder_Order => COUNT(DISTINCT{<flgbackorder={'1'}, Product = {'HJ'}, Outsourcer1 = {$(varHJ_Outsourcer1a)}>}Ordernumber)
varHJ_Outsourcer1a_Backorder_Product => sum({<flgbackorder={'1'}, Product = {'HJ'}, Outsourcer1 = {$(varHJ_Outsourcer1a)}>} number)
varOrdersIpvProducten => 1 or 0; set by Button
flgbackorder => 1 or 0; 1 = order is a backorder, 0 = order in production
flgOrderregelInProductie => 1 or 0; 1 = order in production, 0 = order not in production
The expresions in the charts are:
=If(varOrdersIpvProducten = 0,
$(varHJ_Outsourcer1a_Product),
$(varHJ_Outsourcer1a_Order)
)
OR
=If(varOrdersIpvProducten = 0,
$(varHJ_Outsourcer1a_Backorder_Product),
$(varHJ_Outsourcer1a_Backorder_Order)
)
The dimension is different for each chart and is based on records with flgOrderregelInProductie='1' or flgbackorder='1' or no-selection on both.
Is there a way to change the set analysis part 'flgOrderregelInProductie={'1'}' changed to flgbackorder={'1'}' based by the chart-object where it is used or the dimension in it?
The best solution for me would be; 'flgOrderregelInProductie= and flgbackorder= in one the set analysis with a changing from {'1'} in {'0'} or ={}.