topic Re: Conditional in QlikView

Conditional

Fri, 26 Dec 2014 12:23:55 GMT

Hi,

How to display charts based on the selectio.

For Ex:

Lest Box:

%Chart

EAD

EAD Graph

RW Graph

I have different charts with above names.

If I Select EAD then EAD chart should display, like wise If I select EAD Graph then EAD Graph Chart should displa..,

Thank you.

Re: Conditional

rubenmarin — Fri, 26 Dec 2014 12:29:29 GMT

Hi Raj, in Layout tab you can check 'conditional' on 'Show panel', in ther you can use an expression for each grap, ie. for EAD chart you can use:

%Chart='EAD'

If you want more than one selections to be possible you can check index of a concat function like:

Index(';' & Concat(%Chart, ';') & ';', ';EAD;')--> this will show EAD checrt if EAD is in the possible values

Re: Conditional

Anonymous — Fri, 26 Dec 2014 12:31:01 GMT

Hi!

You can try using this on your conditional rule:

GetFieldSelections(YourFieldName) = 'EAD'

You'll find an example on the attached file.

Regards,

Gabriel

Re: Conditional

Fri, 26 Dec 2014 12:38:02 GMT

Thanks Gabriel

Re: Conditional

Fri, 26 Dec 2014 12:38:21 GMT

Thanks Ruben.

Re: Conditional

Fri, 26 Dec 2014 12:43:22 GMT

Hi,

With the above I can make one selection at time.

But If I want to select 2 charts, I could't

For ex: If I select 2 options- EAD and EAD Graph.

Thank you.

Re: Conditional

Fri, 26 Dec 2014 12:50:14 GMT

Hi,

With the above I can make one selection at time.

But If I want to select 2 charts, I could't

For ex: If I select 2 options- EAD and EAD Graph.

Thank you.

Re: Conditional

rubenmarin — Fri, 26 Dec 2014 12:51:22 GMT

Hi Raj, my second option won't work?, in example:

Index(';' & Concat(%Chart, ';') & ';', ';EAD;')--> this should be the conditional show expression for the EAD Chart

Re: Conditional

anbu1984 — Fri, 26 Dec 2014 13:00:22 GMT

Use Index(GetFieldSelections(Dim1), 'B')

Re: Conditional

Fri, 26 Dec 2014 13:02:23 GMT

Hi Ruben,

I created seperated Inline load like:

LOAD

* INLINE [
%Chart
RWA Summary
RWA Summary Graph
EAD Summary
EAD Summary Graph
PD Weighted Average
PD Weighted Average Graph
LGD Weighted Average
LGD Weighted Average Graph
];

Thats why, Getcurrentfied selection worked.

Thank you.

Re: Conditional

Anonymous — Fri, 26 Dec 2014 13:04:25 GMT

You can try this:

WildMatch(GetFieldSelections(%Chart),'*EAD*')

Re: Conditional

rubenmarin — Fri, 26 Dec 2014 13:06:27 GMT

Hi Raj, please check attachment, i made a simple test document with text objects

Re: Conditional

Fri, 26 Dec 2014 18:41:42 GMT

HI Anbu and Ruben,

Perfectly working with your expression.

Index(';' & Concat(%Chart, ';') & ';', ';RWA Summary;')

Index(GetFieldSelections(Dim1), 'A').

Anbu's Expression is so simple I can understand. Ruben, Could you please explain about your expression if possible, its bit difficulty. I have never used it before like this.

Thank you.

Re: Conditional

Fri, 26 Dec 2014 18:43:13 GMT

Thanks Anbu and Ruben.

Re: Conditional

rubenmarin — Fri, 02 Jan 2015 09:05:15 GMT

Hi Raj,

I think the difficulty aprt of the expressionis the first parameter of the index expression:

It concatenates all possible values in %Chart field, separated by a semicolon, and it adds a semicolon before and after the concatenation, it causes that all values are in format ";[Value];".

That allows you to use ';RWA Summary;' as the second parameter of the index function so it's assured that every value starts and ends with a semicolon and also you can difference between ';RWA Summary;' and ';RWA Summary Graph;'

If you only use index([Values to search], 'RWA Summary') it will return true for 'RWA Summary' and 'RWA Summary Graph'.