topic Re: Replacing only function in the chart in QlikView

Replacing only function in the chart

lprasanth — Sat, 16 Nov 2024 04:33:05 GMT

Hi guys,

is there any way we can move the following only function to the load

idDateStkP date stock projection

1 22/8/2018

2 23/8/2018

3 24/8/2018

4 25/8/2018

5 26/8/2018

6 27/8/2018

7 28/8/2018

=only({<idDateStkP={1}>}[date stock projection])

I had to use this function for seven times to calculate certain values in the chart which taking to long to load since I have plenty of data. I also understand the fact that we can't write a set expression in the load. I would like to have some alternative examples to do the same thing in the load. can you guys pls help me out...

Re: Replacing only function in the chart

pradosh_thakur — Wed, 06 Feb 2019 11:13:19 GMT

May be this but it will restrict the data in the app level and not chart level
where idDateStkP= 1 ;

Re: Replacing only function in the chart

Vegar — Wed, 06 Feb 2019 11:33:38 GMT

You could do as @pradosh_thakur are writing with an where clause if you are ok with excluding the other rows.

Another approach is to create another date field in your table, like this:

LOAD
idDateStkP,
[date stock projection],
IF(idDateStkP=1,[date stock projection]) as [Your New Date Field]
FROM
DataSource