topic Multiple If Conditions in a variable with multiple selection criteria in App Development

Multiple If Conditions in a variable with multiple selection criteria

MaxCld — Sat, 16 Nov 2024 04:03:52 GMT

Hi,

I'm trying to make my app more "ergonomic" with the use of buttons and make the set analysis still "simple" (not to make the if in the set analysis and being redundant).

The first variable vSelectType can be 4 different values Jaune,Vert,Presta and All. Buttons will define the value of vSelectType.

Then in a second variable vType, i try to make a multiple if conditions that will change the selection criteria in my set analysis like :

if($(vSelectType)='Jaune',[Article Vte Famille]={'Bananes'},[Fournisseur Lot Type]=-{'P'},[Fact Ligne Couleur]={'Jaune'},[Fact Type Vente]={'BANANES'},

if($(vSelectType)='Vert',[Article Vte Famille]={'Bananes'},[Fournisseur Lot Type]=-{'P'},[Fact Ligne Couleur]={'Vert'},[Fact Type Vente]={'BANANES'},

if($(vSelectType)='Presta',[Article Vte Famille]={'Bananes'},[Fact Type Vente]=-{'BANANES'},

if($(vSelectType)='All',[Article Vte Famille]={'Bananes'}))))

The set analysis is : sum({$<$(vType)>}[Marge Pds Net])

I think the problem is that Qlik think that the , is part of the if and isn't part of the string to replace, when vSelectType changes.

I tried :

'[Article Vte Famille]={'Bananes'},[Fournisseur Lot Type]=-{'P'},[Fact Ligne Couleur]={'Jaune'},[Fact Type Vente]={'BANANES'}'

"[Article Vte Famille]={'Bananes'},[Fournisseur Lot Type]=-{'P'},[Fact Ligne Couleur]={'Jaune'},[Fact Type Vente]={'BANANES'}"

text([Article Vte Famille]={'Bananes'},[Fournisseur Lot Type]=-{'P'},[Fact Ligne Couleur]={'Jaune'},[Fact Type Vente]={'BANANES'})

It's not working

Anybody has a idea ?

Thank you,

Max

Re: Multiple If Conditions in a variable with multiple selection criteria

Vegar — Wed, 20 Nov 2019 17:47:17 GMT

Have you tried

sum({$<$(=vType)>}[Marge Pds Net])

sum({$<'$(=vType)'>}[Marge Pds Net])

It will be easier to help if you could create a sample app where you have some sample data and your variables and expressions.

Re: Multiple If Conditions in a variable with multiple selection criteria

sunny_talwar — Wed, 20 Nov 2019 18:44:23 GMT

May be try this

If(vSelectType = 'Jaune', '[Article Vte Famille] = {[Bananes]}, [Fournisseur Lot Type] =- {[P]}, [Fact Ligne Couleur] = {[Jaune]}, [Fact Type Vente] = {[BANANES]}', If(vSelectType = 'Vert', '[Article Vte Famille] = {[Bananes]}, [Fournisseur Lot Type] =- {[P]}, [Fact Ligne Couleur] = {[Vert]}, [Fact Type Vente] = {[BANANES]}', If(vSelectType = 'Presta', '[Article Vte Famille] = {[Bananes]}, [Fact Type Vente] =- {[BANANES]}', If(vSelectType = 'All', '[Article Vte Famille] = {[Bananes]}'))))

Re: Multiple If Conditions in a variable with multiple selection criteria

MaxCld — Thu, 21 Nov 2019 11:36:58 GMT

Hi Sunny_Talwar,

Thank you for your answer,

I removed the $() in the if(vSelectType='Jaune', etc... and put [] around criteria and the if variable is now working !

But I still have problem with the synthax of the primary set analysis : sum({$<$(vType)>}[Marge Pds Net])

I already tried with the new if :

sum({$<$(vType)>}[Marge Pds Net])

sum({$<'$(vType)'>}[Marge Pds Net])

sum({$<'$(=vType)'>}[Marge Pds Net])

sum({$<$(=vType)>}[Marge Pds Net])

Not working

Re: Multiple If Conditions in a variable with multiple selection criteria

MaxCld — Thu, 21 Nov 2019 08:48:15 GMT

Hi Vegar,

I tried with the new if of Sunny_Talwar :

sum({$<$(vType)>}[Marge Pds Net])

sum({$<'$(vType)'>}[Marge Pds Net])

sum({$<'$(=vType)'>}[Marge Pds Net])

sum({$<$(=vType)>}[Marge Pds Net])

Not working

Re: Multiple If Conditions in a variable with multiple selection criteria

sunny_talwar — Thu, 21 Nov 2019 12:00:53 GMT

Can you try this

Sum({$<$(=$(vType))>} [Marge Pds Net])

Re: Multiple If Conditions in a variable with multiple selection criteria

MaxCld — Thu, 21 Nov 2019 12:10:30 GMT

It's working perfectly thank you !!