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)
Discussion Board for collaboration related to QlikView App Development.
I have two conditions I want to include in a reporting chart.
If ( [Unit] = 'Grams', [Level])
If ([Unit] = 'Kilograms', ( [Level]/100 )
How can I merge these together?!
I will have more too add but I need this to work first (the others will have similar functions that manipulate the [Level] field
You could use: pick(match([Unit], 'Grams', 'Kilograms'), [Level], [Level] / 1000)
View solution in original post
what do you mean by "merge them together" ?
2 conditions with 2 different results
How about this?
If(Unit = 'Grams', Level, If(Unit= 'Kilograms', Level/100)
Basically I have multiple units such as: Grams, Kilograms, Litres, Pounds etc.
In this chart I only want to display Grams & Kilograms.
But as Kilograms is 100 times bigger than grams I want to divide it by 100.
Hi Marcus, an error appears highlighting the first [Level] section
the answer of marcus is perfect i think
actually ignore me!!
yes he was correct! I didn't notice the field name was 'Levels' which explains the error... Woops!