Discussion board where members can get started with Qlik Sense.
I have a table X in the script.
SQL SELECT ID",
FROM NameLevel ;
$(vY) gives me the columns as shown
And data is shown below:
I have to add a condition in the script where the highlighted data will be null if Flag=1.Here highlighted data in NameL2,L2G2,NameL3,L3G3,NameL4,L4G4 should be replaced by null if Flag=1
How can I do it in back end script. I cannot do this from frontend as there are multiple schema and logic should work on all.
You can change your current variable including the if statement $(vY), or you could create a secondary variable including your conditions like $(vYrules) that contain the rules.
If I have to use the same variable how should the if condition look like in the script? There is no other rule than having flag =1