Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional condition in set analysis :)

Hi everyone,

I am quite new in qlikview. This is my first question in community. Hope to be a question not asked/answered before.

I want to pass some conditions to a dimension, based on selections from an inline load table. Let me give example:

My inline load as follows:

TaxChoice:

LOAD * INLINE [

    Tax Choice

    Excluded

    Surcharge Only

    Total

];

My pivot table is:

pivot.JPG

The dimesion is:

=aggr(Only( {$<DataOrder={1},TaxType=>} [Tax Name]),[Tax Name],[Carrier])

I want to pass TaxType conditions based on Tax Choice table. For example: if "Excluded" is selected as Tax Choice then none of tax should be returned, if "Surcharge Only" selected then TaxType={'Surcharge'} will be returned, if "Total" is selected then TaxType={'Surcharge','Others'} or TaxType= will be returned.

I tried some ifs but I couldn't achieve.

Thanks for helpful answers.

5 Replies
vivientexier
Partner - Creator II
Partner - Creator II

Hello,

Your system is way too complex.

Just change your dimension. Use "TaxChoice" as a dimension.

(Calculated dimension is not a good practice and Aggr() function should be used as a last resort).

Not applicable
Author

Thank you for your reply Vivien, but;

I am using 10 different tables in my dashboard. Sometimes, i need to calculate dimesions, because some dimensions of my objects are not selectable by user. I need to show a dimension from a table based on a conditions of a dimension from another table and this dimension is not selectable by user it is defined by me.

I do not know any options to select my desired results without user's direct interaction.

TaxChoice is a "choice" but does not equal to my TaxType column by means of merging two tables.

vivientexier
Partner - Creator II
Partner - Creator II

TaxChoice:

LOAD * INLINE [

     Dimension, Selection_total, Selection_surcharge_only

    Tax Choice,,

    Excluded,,

    Surcharge Only, Total, Surcharge Only

    Others, Total,

];

What about this ? With this 'inline', you create 2 lists of selection : Selection_total, Selection_surcharge_only ; each list only contains one value. It is like a button for users.

Not applicable
Author

Hi vivien,

I feel that this is the correct approach to this problem, but I coulnd't get it easily.

You can see the TaxType column in data. Then, let us load inline table. So, how do these tables merge without having same columns?

Can you give more detailed explanation please.

Thanks

vivientexier
Partner - Creator II
Partner - Creator II

You just need to change the column name .