topic Re: Clear data in QlikView

Clear data

Anonymous — Thu, 30 Aug 2012 20:32:16 GMT

Hi,

I use Input button, which should clear data. It should be like a filter. If I input 30, I want to see results for N_Month more than 30.

avg({ $< Client*=>, N_Month='$(Variable2)'}[MyField])

Thanks,

CELAMBARASAN — Thu, 30 Aug 2012 20:56:42 GMT

Try this

Is Variable2 is used in input box?if so use

avg({ $< Client*=>, N_Month={">$(=Variable2)"}>}[MyField])

Anonymous — Thu, 30 Aug 2012 21:05:43 GMT

It didn't work.

I have a chart, where I show all student (TOTAL) by month and one of them student.

I want use condition, where I can select min result to show into avg.

Thanks,

Anonymous — Thu, 30 Aug 2012 21:10:06 GMT

I used =sum({ $<N_Month={">$(=Variable2)"}>}[TASK_COMPLETION]) in text box, I got the result.

But in chart, I have dimension MYEAR, It didn't show anything.

Anonymous — Thu, 30 Aug 2012 21:12:04 GMT

It works, but not perfect

Anonymous — Thu, 30 Aug 2012 21:14:29 GMT

Thanks, I changed a bit condition

swarup_malli — Tue, 18 Sep 2012 18:06:47 GMT

In this expression

avg({ $< Client*=>, N_Month={">$(=Variable2)"}>}[MyField])

what is the significance of *=

why is star being used before =

Thnx

Anonymous — Tue, 18 Sep 2012 18:11:05 GMT

You can use without *, it was from previous version of QV.

swarup_malli — Tue, 18 Sep 2012 19:09:56 GMT

Ok, thank you Vovan