Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
carlcimino
Creator II
Creator II

Inline Load with Spaces

Hello, The inline load works for me.  However when I set dimensions and measures in my Object as conditional they don't respond as desired.  For example when I select dimension = Year Built and measure = Account Month Issues I get the image below.  It looks like it has to do with the dimension/measure ending in the same word?  How do you get around?

dimension conditions

=SubStringCount(Concat(_dimension, '|'), 'Year Built')

measure condition

=SubStringCount(Concat(_measure, '|'), 'Account Month Issues')

set Verbatim=1;

Dimensions:
LOAD * INLINE [_dimension
"State"
"County"
"City"
"LOB"
"Segment"
"Month"
"Year"
"Branch"
"Region"
"Producer"
"BDM"
"Producer Tier"
"Prior Carrier"
"ACE/Fund/Chubb"
"Amount of Insurance"
"Year Built"
"Deductible"
"Residence Type"
"Number of Drivers"
"Number of Vehicles"
"Number of VAC Items"
"Liability Limit"
]
;
 
Measures:
Load * INLINE [_measure
"Quoted Premium"
"Issued Premium"
"Quotes"
"Issues"
"Premium Hit Ratio"
"Stick Count"
"Account Month Issues"
"Account Month Issued Premium"
"Current Quoted Premium"
"Prior Quoted Premium"
"Current Quotes"
"Prior Quotes"
]
;

1 Solution

Accepted Solutions
sunny_talwar

Accounting Year should be like this (assuming Year means Accounting Year)

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year|')

Issues:

=SubStringCount(Concat('|' & _measure & '|', ','), '|Issues|')

View solution in original post

5 Replies
sunny_talwar

Try these:

dimension conditions

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year Built|')

measure condition

=SubStringCount(Concat('|' & _measure & '|', ','), '|Account Month Issues|')

carlcimino
Creator II
Creator II
Author

I inserted what you wrote.  It did not work.  I still get a column and measure I do not want.  Do I have to alter the other measure/dimension that it is bringing in erroneously?

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year Built|')

=SubStringCount(Concat('|' & _measure & '|', ','), '|Account Month Issues|')

sunny_talwar

What is your conditional statements for Issue and Accounting Year? I am guessing you would not want to see them because they are not selected, right?

sunny_talwar

Accounting Year should be like this (assuming Year means Accounting Year)

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year|')

Issues:

=SubStringCount(Concat('|' & _measure & '|', ','), '|Issues|')

View solution in original post

carlcimino
Creator II
Creator II
Author

Correct.  I answered my own question by taking your suggested expressions and using them in the other fields.  Seems picky but it makes sense.  Thank you for your help.

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year|')

=SubStringCount(Concat('|' & _dimension & '|', ','), '|Year Built|')

=SubStringCount(Concat('|' & _measure & '|', ','), '|Issues|') 

=SubStringCount(Concat('|' & _measure & '|', ','), '|Account Month Issues|')