Qlikcloud- Variable Input

[Mounika4]

Hi ...

Hi 

 doing migration from qlikview to qlikcloud. so in qlikview they used Input Box Properties > Constraints > Value List > Select 'Predefined Values in Drop-down', >Select 'Listed Value' >  in listed value column  they given some condition ...

in Qlik Cloud ...we have a variable input chart but we dont have option to add that listed values condition ..i tried multipleways but not able to get output

pls help me anyone on this ..how to implement in Qlikcloud

Thank you

[RamanaKumarChintalapati · Accepted solution]

Hi @Mounika4 ,

let’s write your given condition in Inline load of table in Data Load Editor in Qlik Cloud like below

Just Example:

Just call the column name in the variable input Dynamic Value Expression tab like below:

Hope this will help to get idea; this answer will not help to you then please post your clear requirement

I will work on it and let you know.

Thanks!!!

[Mounika4]

Hi Ramana,

below is the Qlikview UI image :they used inpbox box here they used Variable example vfrom

Vfrom defined like this =Only({<MonthIndex = {'$(=Max(MonthIndex)-6)'}>}[Date Short])  ...outputvalue is Jun-2023

as ashow in the above snap

But if we click that highlighted  dropdown..its showing its populating like the below snap

bec , in constrains tabs >listed values >they writen condition 

like this

=If(Len(vToDate) = 0 , Concat(Distinct [Date Short], ',', [Date Short]) , Concat(Distinct If(Num([Date Short]) <= Date#(vToDate, 'MMMM-YYYY'), [Date Short],), ',', [Date Short]))

so here if i used that variable Vfrom its only showing output value i.e jun-2023 ..i tried covert  that listed value condition as a field but not able to get output.

If you have any idea pls let me know

Thanks,

Mounika k.

[RamanaKumarChintalapati · Accepted solution]

Hi @Mounika4 

Here I have tired like below, Expression is changed like this to get list of values,

=If(Len(vToDate) = 0 , Concat(Distinct [Dateshort], '|', [Dateshort]) ,

Concat(Distinct If(Num([Dateshort]) <= Date#(vToDate, 'MMMM-YYYY'), [Dateshort],), '|', [Dateshort]))

Is this your requirement or whenever selected the buttons the data set changed according to selection?

Moreover, the Input variable selection will not impact sheet visuals.

Thanks!!!!

[Aasir]

Try this create a variable in data load editor and set its initial value based on your condition.
In your charts you can use the variable created, if vTest is your variable.
 =If($(vTest), YourTrueExpression, YourFalseExpression)