Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to visualize data containing specific & repeated values
The expected result is a histogram with the folowing data:
A => 3 customers (C1, C3 and C5)
B=> 4 customers
C=> 2 customers
I would like this histogram to have selectable fields in order to filter the data easily.
Functions like "valuelist" doesn't work because it is not possible to filter the data. It might be possible with new independent set of data but I don't know how to implement them.
This is a quite simple request but I didn't found any solution yet
Many thanks in advance,
Do you have a character between individual category? Assuming that character is ;, you can try this
LOAD * INLINE [
LOAD Distinct Category,
SubField(Category, ';') as Category_Selection
This is a very good idea Sunny, many thanks.
however, there is no such character in the data set.
Any other proposal?
If not, I would modify the original data according to your solution but it would be better if there is another solution.
If category is only ever going to be a single digit thing, then may be this
Mid(Category, IterNo(), 1) as Category_Selection
While IterNo() <= Len(Category);