Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

indirect set analysis question

Hi,



Here is indirect set analysis expressions I implemented;

sum



({$<Month={$(e_Month_1)},TransactionID=p({<Rating={'AAA'},Month={$(e_current_Month)}>})>}sales)

sum({$<Month={$(e_Month_2)},TransactionID=p({<Rating={'AAA'},Month={$(e_current_Month)}>})>}sales)

I'll explain the expression with an example, if I select August as current month, it holds the transactionIDs that have AAA rating and apply to July. So TransactionIDs can have different ratings in July but still holds the same transactionIDs and sum up those transactions' sales on July.

Second expression has same concept but comparing August with (month-2) June. I am drawing those three lines and bars in chart but I am having different number of transactions for August, July, and June. I believed if I wrote the expression right, I should have same number of transactions.

Since I am new to indirect set analysis, I appreciate comments and advice.

Thanks!

Ryan

0 Replies