Discussion board where members can get started with QlikView.
LOAD * INLINE [
and i have a productName in Product Table too,i created a pivot table with dimentions as ProductNAme ,Office etc and given expression as below,
can any expalin how that expression working
i guess you are asking about adhoc reporting.
concat will create a string with delimter '|'.
for example: A|B|C|D|E|F|B
substring will return count of the word/letter you mentioned in substring count
in mentioned example if we write as substringcount('A|B|C|D|E|F|B','B')
the above will return 2 as B is repeating two times.
in your example the substringcount(concat()) will retune 1 as ProductName is repeated once in the _Dimension.
as it returns one,the conditon enable and become true.
so when even you click on _Dimension the count shows 1 and condition will enable and chart will display respective selection.
Hope it helps you.
View solution in original post
Let's talk with inline
_Dimension is the field which contains A, B, C, D ??
So, Concat(_Dimension, '|') -- Will return A|B|C|D
From here, We are going to use
SubStringCount(concat(_Dimension, '|'), 'C') -- Which contains one as Count
Thank you so much ,it held me a lot
you are welcome Vignesh