topic Re: Qlikcloud- Variable Input in Visualization and Usability

Qlikcloud- Variable Input

Mounika4 — Tue, 12 Dec 2023 14:55:41 GMT

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

Re: Qlikcloud- Variable Input

RamanaKumarChintalapati — Wed, 13 Dec 2023 04:41:04 GMT

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!!!

Re: Qlikcloud- Variable Input

Mounika4 — Wed, 13 Dec 2023 07:10:33 GMT

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.

Re: Qlikcloud- Variable Input

RamanaKumarChintalapati — Wed, 13 Dec 2023 12:29:15 GMT

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!!!!

Re: Qlikcloud- Variable Input

Aasir — Wed, 13 Dec 2023 13:17:43 GMT

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)