Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with embedded IF statement

I have an industry hierarchy in my qvw: Industry -> Product -> Sub Product. I have a drill down dimension in my straight table that is: Industry -> Region -> Sub Region -> Client (or others that mix the geography hierarchy and industry hierarchy)  To find the most specific industry selection, I can do:

=IF(not isnull([Sub Product]),[Sub Product],

IF(not IsNull([Product]), [Product], Industry)))

as an expression in my table. That way if the dimension is Product, the expression will reflect the different products in each row. Otherwise if I have drilled past Product to Region, all rows will reflect the product selected.

My problem is that I would like to use this most specific industry in my set analysis, doing something like:

=sum({$<%Franchise={"$(=IF(not isnull([Sub Product]),[Sub Product],

IF(not IsNull([Product]), [Product], Industry)))"}>} %Rank)

where %Franchise is one field of an inline table.  If you have any suggestions it would be greatly appreciated.

2 Replies
christian77
Partner
Partner

Hi.

Set for not is null

Franchise={'*'}

That means, it has to have a value, therefore is not null.

You may use it.

Not applicable
Author

I want the Franchise selection to be the lowest level industry selection, not just any value.