topic Re: Hard Coded Values in QlikView

Hard Coded Values

SJ_16 — Thu, 15 Nov 2018 11:11:16 GMT

Hi,

I have a variable called 'Company' of which is used as a Filter and this has two options - RI and NT each has there own values. So when I select the individual options, the charts change as expected.

However what I need is one variable 'FC_New' to show a hard coded value of 70 when the filter is not selected.

This is my existing measure logic:

sum({$<CV_Year={$(=YEAR(TODAY()))},[Dash]={'Rate_On'}>}[Budget Value])

I'm assuming I would need to create a new variable like below and call it say 'vRate'

if(getselectedcount([Company])=0,70,1))

and then my measure logic will look something like

sum({$<CV_Year={$(=YEAR(TODAY()))},[Dash]={'Rate_On'}>}[Budget Value]) / $vRate ?

Re: Hard Coded Values

sunny_talwar — Thu, 15 Nov 2018 11:59:55 GMT

Looks good... but just make sure to use $(vRate) instead of $vRate

Re: Hard Coded Values

SJ_16 — Thu, 15 Nov 2018 12:01:50 GMT

Thanks, I have tried that but doesn't work, it just adds the values together when the filter hasn't been selected rather than displaying 70

Re: Hard Coded Values

marcus_sommer — Thu, 15 Nov 2018 12:05:16 GMT

Try it with:

vRate: if(getselectedcount([Company])=0,0,1))

and then:

alt(sum({$<CV_Year={$(=YEAR(TODAY()))},[Dash]={'Rate_On'}>}[Budget Value]) / $(vRate), 70)

- Marcus

Re: Hard Coded Values

SJ_16 — Thu, 15 Nov 2018 12:09:12 GMT

Thanks for your suggestion Marcus. I have tried this but the values still seem to add up.

Re: Hard Coded Values

marcus_sommer — Thu, 15 Nov 2018 12:18:18 GMT

It should work - at least if I use the following as dummy:

= alt(100 / GetSelectedCount(Application), 70)

it worked. Therefore check if you use the right field/variable or if there is any typo or something similar.

- Marcus

Re: Hard Coded Values

sunny_talwar — Thu, 15 Nov 2018 12:20:51 GMT

Would you be able to share a sample where we can see the issue?

Re: Hard Coded Values

SJ_16 — Thu, 15 Nov 2018 12:28:05 GMT

What it looks like the logic is doing is hard coding a value of 70 to each individual Company.

What I should see when selecting the filters are -
Company:
RI = 75
RT = 65

When the company hasn't been selected I should see 70 (as the hardcoded value)

What is happening with the logic used is this
RI = 70
RT = 70
No filter selected = 140

Re: Hard Coded Values

sunny_talwar — Thu, 15 Nov 2018 12:31:11 GMT

In your example, 75 and 65 are just Budget Values? Or what exactly are they?

Re: Hard Coded Values

SJ_16 — Thu, 15 Nov 2018 12:33:54 GMT

Yes, that's right

Re: Hard Coded Values

sunny_talwar — Thu, 15 Nov 2018 12:39:48 GMT

May be you need this

If(GetSelectedCount(Company) = 0, 70, Sum({$<CV_Year = {$(=Year(Today()))}, [Dash] = {'Rate_On'}>} [Budget Value]))