This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to write out the correct logic for an IF statement, but the syntax is incorrect, can anyone please shed some light as to what is wrong here please?
count(Purchase_Volume) + $(v_Extra Volume) + (v_Product = 'DIST'), count(Purchase_Volume) + $(v_Extra Volume),count(Purchase_Volume) + $(v_Extra Volume) + (v_Product = 'TUPA'), count(Purchase_Volume) + $(v_Extra Volume),count(Purchase_Volume) + $(v_Extra Volume) + (v_Product = 'DGUTA'), count(Purchase_Volume) + $(v_Extra Volume)
what is v_product??? variable or field??
can you share defination of variable $(v_Extra Volume)
In response to your previous question, if you have product as a dimension in your table, the following should give you the behavior you were looking for:
Note: depending on how you variable input is setup, you may need quotes:
v_Product is defined from the variable 'Product_Grouped'. I am using v_Product due to having this as a Variable Input Button.
Similar to v_Extra_Volume, this is also a Variable Input (Input Box).
The IF statement (I am hoping) will allow me to then key in 100 to the v_Extra_Volume input box, select v_product button, then my table will update based on these selections.
well if your both field are input variable. out of that 1 input variable is comparing for product name and another for extra volume,
and in all case you just want to add v_extra_volume + count(Purchase_Volume)
then why don't you just write
Thanks for your suggestion Gary, the second option works syntax wise, but the increase still adds to all Products opposed to showing as a 0