Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
can someone please explain me the below expression..
=IF(GetSelectedCount(Market)=0, SubField(Concat(DISTINCT Market, ','),','), subfield(GetFieldSelections(Market),',' ))
Consider that you have below in your script..
Load * Inline
[
Market
A
B
C
D
E
F
];
=IF(GetSelectedCount(Market)=0, SubField(Concat(DISTINCT Market, ','),','), subfield(GetFieldSelections(Market),',' ))
Here if condition is checking whether user has selected any value from Market list box...
if not selected...
SubField(Concat(DISTINCT Market, ','),',')
Concat(DISTINCT Market, ',') will concatenate all market and
SubField(Concat(DISTINCT Market, ','),',') will give you First Market i.e. 'A'
If Selected
subfield(GetFieldSelections(Market),',' ) will give you First Market from User Selection...
If you still having confusion understanding this code, please refer QlikView Reference Manual and try to understand
if, Concat and Subfield funcitons...
hi shitej how is mahindra and mahindra
If there is something selected in Market field, it will get the 1st value in the list of selected Market values, else It will get the 1st value in all Market Values. in fact, this expression will always returning the same information no matter there is a selection or not.......
Hi, thanks for the explanation
I have a question following..
how is,
1. Checking the Always One Selected Value in the properties of the Market text box field here and,
2. writing a trigger expp.
=IF(GetSelectedCount(Market)=0, SubField(Concat(DISTINCT Market, ','),','), subfield(GetFieldSelections(Market),',') )
different from each other..? how do they effect the remaining items in the sheet..?
Hi, thanks for the explanation
I have a question following..
how is,
1. Checking the Always One Selected Value in the properties of the Market text box field here and,
2. writing a trigger expp.
=IF(GetSelectedCount(Market)=0, SubField(Concat(DISTINCT Market, ','),','), subfield(GetFieldSelections(Market),',') )
different from each other..? how do they effect the remaining items in the sheet..?
it means conditions is always false then what is need to write that condition
Nice Explanation..!
Sounds like you are using QlikView and not Qlik Sense. Is that correct?